|
|
Missing Excel Files--- PLEASE HELP!!! by
Nicole
I was working in Microsoft Excel today. I had 2 spreadsheets open I edited and saved both of them. When I returned to excel and tried to open the files......
|
|
4 |
257 |
|
|
|
|
1 |
275 |
|
|
|
|
1 |
451 |
|
|
Lookup a value across sheets by
KSpider
I have a master sheet of workers names, the names are in the A column.
in the B colm i want a formula that will go thru department sheets and
find the name in...
( 1 2)
|
July 29th, 2004 06:18 PM
by hgrove
|
11 |
361 |
|
|
|
July 29th, 2004 05:56 PM
by hgrove
|
1 |
153 |
|
|
xml schema update by
Carl
Is there any way to avoid remap everything when you only make small change to your xml schema? anybody has experience on this? thanks.
Carl
|
July 29th, 2004 05:52 PM
by hgrove
|
1 |
248 |
|
|
|
July 29th, 2004 05:15 PM
by dremel
|
0 |
430 |
|
|
ODBC Select Data Source by
bunzl
Hi,
I have users who generate ODBC queries in Excel 2000 using system
dsn's.
I have system dsn's set up which are pointing to the same databases as
the users....
|
July 29th, 2004 05:13 PM
by bunzl
|
2 |
523 |
|
|
|
|
2 |
441 |
|
|
Gridlines / No Gridlines by
BillCPA
I have downloaded a spreadsheet that has none of the automatic gridlines in the area where the data is. I have gone to the Options tab and made sure the...
|
July 29th, 2004 04:04 PM
by BillCPA
|
5 |
305 |
|
|
CommonDialog Problem by
Nny
Every time I use the commondialog control, it seems to
remember the last path and filename is opened. I need to
clear this information and have it use a...
|
|
1 |
158 |
|
|
Macro Error: Unable to get Var property by
Peter Bernadyne
My macro appears to have trouble calculating variance (using the
worksheet function) for a range of cells I have.
The code I have is:
Lead_Y =...
|
|
2 |
282 |
|
|
what is the best way to do this? by
mck
I have data that I have exported from Access. The data is
over time and is a 27 question survey. There are also
over 30 departments. The questions have...
|
July 29th, 2004 03:18 PM
by mck
|
2 |
146 |
|
|
|
|
2 |
329 |
|
|
|
July 29th, 2004 03:03 PM
by clane
|
2 |
305 |
|
|
Sorting by multiple names in excel by
JulieD
Hi Scotty
Easiest option is to use the Data / Text to Columns feature to separate the
names
(delimited & space as the character)
Select the column with the...
|
July 29th, 2004 02:35 PM
by
|
1 |
665 |
|
|
Stuck spreadsheet by
Kathy
I have a spreadsheet that is shared and someone has
dragged up so high you can't get a hold of it to drag it
back down to make it all visionable. Any ideas on...
( 1 2)
|
|
11 |
245 |
|
|
#N/A by
Rob Lloyd
Hi,
I'm using a VLOOKUP formula that looks for a value in one sheet and, if it finds it, putting the value in another sheet. This works fine and as I am...
|
|
1 |
123 |
|
|
Macro to extend a pivot table range by
Debra Dalgleish
You can use a dynamic range as the source for the pivot table. There are
instructions he
http://www.contextures.com/xlPivot01.html
Phil Platt wrote:
...
|
July 29th, 2004 11:56 AM
by Vaughan
|
1 |
522 |
|
|
Hide colum by
rodw
I want to hide colums based on a cells value
so say if a1 = yes i want to hide colums b to f
and if a1 is no then i want to hide g to j
Is thi possible
---
|
July 29th, 2004 11:51 AM
by rodw
|
2 |
290 |