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

johnandbeth · Apr 9th, 2002, 10:15 AM

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 · Apr 9th, 2002, 06:07 PM

Beth,

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

Dexter

johnandbeth · Apr 10th, 2002, 06:42 AM

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 · Apr 17th, 2002, 01:09 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 10:15 AM	#1
johnandbeth Board Regular Join Date: Apr 2002 Posts: 164	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

Apr 9th, 2002, 06:07 PM	#2
Dexter Board Regular Join Date: Apr 2002 Location: St. Louis Posts: 71	Beth, Have you tried the DATA-FORM command from the menubar? Dexter

Apr 10th, 2002, 06:42 AM	#3
johnandbeth Board Regular Join Date: Apr 2002 Posts: 164	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

Apr 17th, 2002, 01:09 PM	#4
johnandbeth Board Regular Join Date: Apr 2002 Posts: 164	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