I have approx 6 spreadsheets I need to merge into one document to receive a
final result. Each spreadsheet will be worked by a different indiviudual.
- Aug 14 Mon 2006 20:08
rolling up several spreadsheets into one
- Aug 14 Mon 2006 20:08
Sort a Spreasheet by Color Highlights?
Is there a way to Sort a Spreadsheet by Color? I have an enormous spreadsheet
with yellow highlights scattered through and I want to sort by the
- Aug 14 Mon 2006 20:08
How can I update a graph with autofiltered data?
I want to be able to set up graphs which will update automatically once
differed filters are applied using autofilter. Can this be done?
- Aug 14 Mon 2006 20:08
How to I add Smart Tag that was removed?
I am using the Smart Tag feature for updating stock quotes. I selected the
Remove this Smart Tag to remove a Financial Symbol from one worksheet, and
- Aug 14 Mon 2006 20:08
How do I stop VLOOKUP from asking what spreadsheet to look in?
Every time I use VLOOKUP on a certain PC it asks what path to take. The path
is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
- Aug 14 Mon 2006 20:08
How can I sort text (in excel) while ignoring articles (e.g., the
I work in a library and want to sort lists of CD titles. I want to sort the
list alphabetically while ignoring articles (e.g., the, a, an) when they
- Aug 14 Mon 2006 20:08
Removing leading 0s
I have a sheet of 10K rows that have entries like this: 000345, 0034567,
0000067 etc. I am trying to do a vlookup on another table of 10K rows and
- Aug 14 Mon 2006 20:08
Lines on chart don't correlate to values being charted
I'm having a strange problem with a chart done in Excel 2003 (on a workbook
prepared by someone other than myself, so I'm not sure of all that has
- Aug 14 Mon 2006 20:08
Deleting/rasing a column of numbers??
I have a worksheet 18 columns by 16 rows. I want to delete only
the numbers in a specific column. I don't want to lose my formulas.
- Aug 14 Mon 2006 20:08
combine rows into one cell separated by comma
Need to combine 100 email addesses in separate rows (in Excel) into one cell,
separated by comma, so I can do mass mail. Formula I'm trying won't work.