Or have the macro goto the appropriate sheet automatically. If not possible,
an inputbox asking for the sheet name to be entered or selected from a drop
down.

--
Don Guillett
SalesAid Software

"Groggy" wrote in message
...
Don, thanks for the response. I'd thought of a macro though there are
two main sites feeding data. Each site sends the same sheet of info
with the site only identiable by the sender's name.

I am beginning to think the best I can do is place a macro in the
sender's sheet to autoselect and copy the data, then have the user
navigate to the appropriate day in the data entry sheet and hit paste.

Greg

On Sat, 15 Apr 2006 07:34:52 -0500, "Don Guillett"
wrote:

If I understand your problem, I would develop a macro that opens each
workbook in a list and copies the info to the next available row and then
closes the workbook.