A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
How to Export as text file with NO delimiters or modifications? by MojoNixon
hello all, I am simply trying to save a sheet as a text file with the column contents saved as a simple long string of data, regardless of content. Ex. If my...
August 15th, 2006 09:37 PM
by MojoNixon Go to last post
5 106
Data validation by Bill
I have a validation list on sheet 1 and I need the selection from that list to take me to sheet 2 or sheet 3 -- Bill
August 16th, 2006 05:19 PM
by Dave Peterson Go to last post
5 137
Column Header tabs A-Z by DOGMA-DOT
I just got a new spreadsheet via email. Pulled it up. The A-Z column headers don't show. I pulled up another worksheet and the column headers are fine. The...
August 17th, 2006 01:49 PM
by DOGMA-DOT Go to last post
5 85
I need to combine two excel worksheets in one pivot table. by Ellie
My data is larger than one excel worksheet is capable of so I have split it by months. It has already been summarized as much as I can. Can I use two or...
August 16th, 2006 04:25 PM
by Ellie Go to last post
5 82
lOOKUP by Stuart Carnachan
I WOULD LIKE TO CROSS REFERENCE A TABLE AS BELOW TO PICK OUT THE VALUE in A3 if i input "Training" in A1 and grade "3" in A2.Conversley if i change to driver...
August 17th, 2006 02:41 PM
by Sloth Go to last post
5 79
List Question by metaltecks
I have a spreadsheet that contains a total of 2000 lines of data. I want to be able to copy the first cell, A1-a2000, and put them in notepad program. The...
August 17th, 2006 04:51 PM
by Dave Peterson Go to last post
5 118
To enter a date by Jaleel
Is there a way in Excel to enter a date without slashes or dashes?
August 17th, 2006 11:50 AM
by Bob Phillips Go to last post
5 84
macro code to sort a range by ashish128
Hello All, I tried searching in the group but found nothing of what I was looking for. I have a .xls file with 10 worksheets in it. assume that sheets...
August 17th, 2006 05:52 PM
by Gary''s Student Go to last post
5 86
convert a column of data from Kb to MB by almostki
Hi all, Thank you for reading this, I was wondering if it was possible to have a macro convert a colum of data from Kb to MB ? Thanks ! --...
August 17th, 2006 05:42 PM
by Gord Dibben Go to last post
5 130
Need to send a fax via a fax server from excel by NSKearns
Good Morning. I would like to send the active workbook as a fax via a fax server using outlook. In order to do this I select File - Send to -...
August 16th, 2006 03:25 PM
by Dave F Go to last post
5 74
Is it possible? by Bobbie Jo
But I have a list of number where 6 equals 500, 7 equals 600, 8 equals 700, and so one. (Probably about 20 of them) So I came up with...
August 17th, 2006 08:55 AM
by JC Go to last post
5 122
"Global" Cell Formatting by Philma
I have a folder full of about 300 Workbooks. Inside the Workbooks, I'm using cell formatting text control "shrink to fit" to be able to view varying length...
August 15th, 2006 08:19 PM
by Philma Go to last post
5 67
Show address of Access Database by FA
Hello, I have a pivot table that get its data from an Access database. I want to show the address of the access database in a cell in the spreadsheet that...
August 15th, 2006 01:33 PM
by Ildhund Go to last post
5 100
Date Formats by Greenback
I have a spreadsheet sent to me and it has a column of dates in the following format - mm/dd/yy I would like to change them to yyyy/dd/mm but I can't seem to...
August 15th, 2006 08:32 AM
by Greenback Go to last post
5 81
PivotTable Nightmare by Sandi
Everytime I refresh my pivot table it keeps dropping part of information on my spreadsheet. I have a list of agencies in alphabetical order and each time I...
August 15th, 2006 12:27 AM
by Debra Dalgleish Go to last post
5 64
Making data validation drop down list wider by Steve E
My VB is very weak (trying to learn). I've followed the instructions on Debra Dalgleish's site for adding code to the worksheet and it works fine for a...
August 15th, 2006 05:15 PM
by Dave Peterson Go to last post
5 72
Too Complicated For Me by mehare
This is what I want to do: If info in Sheet 1, Column A matches a sheet name, then paste info from Sheet 1, Columb B to B3 of the sheet with the matching...
August 16th, 2006 02:57 PM
by carstowal Go to last post
5 122
Does anyone know of a service/company that builds macros? by punter
Hi all, I've got a couple of macros that I am looking to have built. They are not the most complicated macros in the world but a little out of my range right...
August 17th, 2006 02:43 PM
by punter Go to last post
5 97
Distinct list formula by summergs
Does anyone know of a formula I could use to compile a distinct list of entries from another column. I know this could be done with the advanced filter, and I...
August 16th, 2006 06:12 AM
by Biff Go to last post
5 95
help with formula by Richard
If B16 (which is a date) is between January 1st. and June 30th. then 3 If B16 (which is a date) is between July 1st. and September 30th then 2 If B16 (which is...
August 17th, 2006 10:57 PM
by MyVeryOwnSelf Go to last post
5 83
Post New Thread


Display Options
Showing threads 20001 to 20020 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.