Excel 2003: Filling a form with data from spreadsheet

Hi all,

I had a thread about this earlier but I could not find it with a search. I have a workbook that has several worksheets. I found some VBA code on the web. I figured out how to adapt it to fill a form ( the "Cover Letter" tab) with data. The data is pulled from a worksheet called "Numbering". Now I need the macro to pull the data from a worksheet called "Update Notice List".

I thought from the way the code looked that it would simply pull data from the row that had been selected on any worksheet. It doesn't. Can you help me to change the code so that it pulls data from the "Update Notice List" worksheet?

The spreadsheet I am pulling the data from contains 245 rows (records). I need specific data from those rows to populate a form letter so that folks can be notified that documents they own need to be updated.

I just have to make the cell references once in the macro. As it is now, if I place the cursor in the "B" column of the "Numbering" worksheet. The document name, review date, review frequency are all populated to the appropriate fields in the "Cover Letter" tab filling in the cells on the form when I run the macro. I need to add the document owner's name to the form. That data currently resides in another worksheet in the same workbook.

In the code that I got from the WWW, I don't see any reference to the worksheet the data is being pulled from i.e. "Numbering". So, I don't know how to get it to pull the data I need from the worksheet named "Update Notice List".

Got it figured out! The macro does work for whichever row on whichever worksheet is selected. I was selecting a cell that didn't have any data, therefore the macro was giving me the error msg that was specified if there wasn't any data in the selected cell. Phew! Thanks for the help.