Subject: VLOOKUP and  Multi Lists
need help with this dropdown multi list with vlookup.
B1 is the dropdown list (on sheet named Data)  that holds 4 lists (ad,
el, mr, sz) this are lists that hold the codes for group names (TB =The

I have a load of spreadsheets that I need to file in the same folder.
The problem is each one has the same filename. Does anyone know how to
save a file as the date that it was created on thus saving me having to
go through 100's of files and do it manually.

I there i have a big woorkbook and i woul like to add some kind of inde
in the first page so I could have a better track of my data.
Like a cover page, instead of opening in the last page when I saved th
document.

I have a rather large spreadsheet that I copy/pasted off the net. It's
test data on the students in my school. When I copied the info into
Excel, their names, headings, and data all come with hyperlinks that
lead me to this testing website. My question is this: Is it possible to

Preliminaries:
1) Have looked in archives - either don't know how to describe this well, or
can't find similiar challenge
2) Have looked in my Excel 2003 Help files - either don't know how to

When I open an excel document nothing comes up.  Just a grey background, like
the document is minimized in Excel.  I can go to file open and search for it
and open it that way.  Any ideas?

OK I hope you guys can help me out.  Here is the scenario.  I have 3
spreadsheets.  The main spreadsheet I working with has 500 lines with a
unique number string.  The next two spreadsheets have about 12000 lines
but also contain the same unique string as the first spreadsheet.  I

to compare a list of names or numbers... I would always seem to use two
VLOOKUP formulas...
i.e.. find A1 in B:B  and find B1 in A:A
does anyone know a better way?

Hi, I'm a newbie and would like to understand macros and VBA. My
problem is,  I do not understand the basics. Can anyone recommend some
good website  for  tutorials or books for beginners?
Thnaks in advance

I put blank rows between each row which makes it easier to read my spread
sheet. When I sort the data the blank row disappears. How do I keep this from
happening? Thanks

Hi All: Microsoft Excel 2003 (11.6560.6568) SP2 on XP sp2.
Recently, Excel hangs for about 5-10 seconds when I try to paste text into
any type of field...general, text, number, etc. I'm just copying text off an
HTML page in IE6 and pasting it into a cell in Excel. I had done this

How do I calculate compound interest like a bank account as interest
being calculated daily.
Thanx in advance.

My sister uses Excel and yesterday she clicked onto what looked like a
microsoft message on
resizing messages and since then she gets a message saying Windows cannot
open the xls files. We tried restoring the PC to an earlier date but that

My sister uses Excel and yesterday she clicked onto what looked like a
microsoft message on resizing messages and since then she gets a message
saying Windows cannot
open the file. We tried restoring the PC to an earlier date but that did not

I have a column of data in workbook 1 and I have 20 columns of data with 600
rows in workbook 2 I want to search workbook 2 for the data I have in
workbook 1