need to copy data from worksheet to month's worksheet - help

[johnandbeth]

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

 

[Dexter]

Beth,

Have you tried the DATA-FORM command from the menubar?

Dexter

 

[johnandbeth]

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

 

[johnandbeth]

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