Now....the rest of the story. Kids were in Excel doing who knows
what...NOW, the only way I can open an excel spreadsheet is if it is in
the excel history. All shortcuts as well as WE will open excell....BUT,
no file opes, blank screen. To open at that point you have to click

I am writing a macro which i need to search through a list of data containing
peoples names, and if found return the value in the cell adjacent to it on
the right.
This i can do, however the list of names changes depending on whether or not

I have an application where every month, I get a new set of data to add
to the old. The new data is on a separate sheet. I want to record a
macro that till copy the new data, add it at the bottom of the
complete, existing list of data, then sort on one field and put in a

Can I enter data interactively and dynamically?
To give an example:
Approach 1: Currently, when I enter grades for students, I have to find
his/her name first, after finding that row, I have to scroll the row to the

I have seen some files in which there are dropdown and options buttons. But
they are not operating with macros. They are just linked to some cells. How
to create such dropdowns and option buttons.

I have a document where I have the name of 10 people in cells "A2" to "A11".
In cells "B2" to "B11", I have everyone start time.  In cells "C1" to "S1",
I have the different start hours during the day (8:00, 9:00, 10:00, etc...)
In cells "C2" to "S11", I would like every cells to ...

i need a macro to find parts of an address and move to another colmun. like
213 smith rd apt 2
that is in column e and move or copy just the apt 2 in column f and then
delete it from column e.

Basically I have 13 cells spread out over a spreadsheet that normally have
zero values. What I want to do is count the number of them that have
non-zero (actually will be greater than zero) values and return that value
in another cell. What I was thinking of was using COUNTIF, but ...

I  need to seperate the words and demensions from A1 to A2(all
centence) and A3(Demensions). Can somebody help me. I do have 3000
items in my list.
Thanks

How can I get a vlookup (or another function) to look for the DATA in
the last row in of a column.
For ex... have data in column A... rows 1-5 have data filled in.
How can I get it to tell me what is in A5?

I have columns A-Gthat include A - Parents name, C-players name, E-  Phone
numbers, and  G-email address.  I want to sort in Alpha order, but all cells  
must match the original imput.  How do I do this?

Please excuse if this should go in a MS Publisher newsgroup.
I have list of names in Excel.  I am trying to merge/print an
MS Publisher document that is exactly one sheet.  The sheet
itself has room for three of the same exact prayer.  So,

Hi. I've registered a macro, how can I execute it every time that I open the
document??
Thanks

1) The RAW DATA SHEET is where I maintain a cash receipt register in a list form on a daily basis. Any date may have multiple entries due to different customer payment.
2) The SUMMARY SHEET shows how I want to summarize the data contained in RAW DATA SHEET. Basically the summary ...

In Excel, as in most MS programs, you can click on File and see a list of
recently opened documents for that program. Is there a way to increase the
number of documents viewable in this history with a reg key or something?