|
|
|
|
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
|
|
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...
|
|
5 |
85 |
|
|
|
August 16th, 2006 04:25 PM
by Ellie
|
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
|
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...
|
|
5 |
118 |
|
|
To enter a date by
Jaleel
Is there a way in Excel to enter a date without slashes or dashes?
|
|
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...
|
|
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 !
--...
|
|
5 |
130 |
|
|
|
August 16th, 2006 03:25 PM
by Dave F
|
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
|
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
|
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
|
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...
|
|
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...
|
|
5 |
64 |
|
|
|
|
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...
|
|
5 |
122 |
|
|
|
August 17th, 2006 02:43 PM
by punter
|
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
|
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...
|
|
5 |
83 |