Beth,
Have you tried the DATA-FORM command from the menubar?
Dexter
I have a data entry worksheet. I want to create a macro that will copy the data onto the appropriate month's worksheet. For example, if I enter on the data entry worksheet that this call came in on 01/02/02, then list the details of the call in the adjoining column, I want the entire row to copy onto the first empty row on the correseponding month's worksheet (January, in this case). I want the call report to remain on the data entry worksheet, but also to appear on the month's worksheet.
Is this possible or do I have to copy and paste each time?
Thanks for any help!
Beth
I don't see where that will put the information on both the data entry tab AND the correct month's tab. Am I missing something?
Thanks for responding!
Beth
I'm hoping to copy the information by date onto the first empty row of its corresponding worksheet (in the same workbook). Any ideas?
Thanks!
Beth
Like this thread? Share it with others