I have to do 3 reports for work.  They basically have the same
information on them but different orientation. The first report
requires more data than the 2nd and 3rd report. Is there a way to
enter the data in the 1st report and the relavent data trickle down to

Col A5:A? conatins names of clients that repeat over time, Col B contains
codes " BW, COL, HC" AND OTHER CODES.
In Col D5:D? is a list of the names in Col A but listed only once, Column
hedding are in: Col E4 is BW, F4 is COL, G4 is HC.

When I open a one of my files it opens two files of the same name but with a
different number on the end. E.G. the file name is "Past Players:1" and the
other file name is Past Player:2, the original name is Past Players without
the number.  

Excel 2002 SP3
Win XP Pro SP2
Hi,
Is there a way to do a Save All (all opened files) in a similar fashion

I have the following info in col C
7820 Jeanne D'Arc blvd, Orleans, Ontario M1C2E9
I would like to leave 7820 Jeanne D'Arc blvdin col c
and place  Orleans in col d

I copy a control worksheet sheet(2) from the active workbook it places
it before the control sheet.  I want to change the name of the new
sheet.  The last line where I want to assign the name gives me a 1004
runtime error.  Can you tell me how to name the sheet?  the copied

I'm sure this is somewhere out on the net, but I can't find it.
How do I create a list on a new tab, from a list of values that were
imported into the workbook?
Tab 1

When protecting a worksheet, what options must we select as exceptions in
order for the user to be able to expand or collapse outlines when the
worksheet is protected?  If there is such an option does it open the door to
other unexpected edits?

I have some data in the following format:
Number firstname lastname schoolname
The first three fields are one word each. Schoolname can be more than
one word. I'm trying to parse the data using the data -> Text to

One worksheet in a workbook is very slow to scroll (page up/down, mouse
scroll, and scroll bar). Excel 2003 was fine. Now scrolling takes several
seconds per page.
This worksheet has over 5000 rows and 20 columns. If I delete 75% of the

I have had a problem with sorting by dates and sometimes with numbers after
pasting files from MS Access 2003 into Excel 2003.  I use Access to query
out files that I need to analyze, then I analyze them in Excel.
I have had instances when some of the files will not sort ascending ...

I have a spreadsheet that acts as a template.  Because of that, there
may be data in rows 2-10, but nothing below row 10.  Data in columns A
through Z feed formulas in columns AC through AL.  Prior to putting
any data in columns A through Z, the formulas in columns AC through AL

I am trying to use a variable in an address to call up historical
prices for stocks out of Yahoo.
With ActiveSheet.QueryTables.Add(Connection:="URL:htto://finance.
yahoo.com/q/hp?s=ibm", Destination:=Range("A1"))

I need something like a List in Excel - but it's not technically for sorting
and I don't want it at the header line.
Picture a regular application with a Dropdownlist/combobox
This list has a lot of items in it, that I want to choose from on every line

when i open an excel file excel also attempted to open my archive.pst
file and a couple other non-related pdf files.
Why might this be and how can i fix it?