Copying Data from 1 Worksheet to another Worksheet (Accumulative data)

Hi all, I’m new to Excel Macro and was given an assignment to copy data from 1 worksheet (A) to another worksheet (B) within the same workbook.

Here goes:

Worksheet A stores monthly data and will be deleted after the next month’s data is send in

Worksheet B stores accumulative data copied from Worksheet A.

Worksheet A’s data: Date, Case#, Location, Duration, Comments and Comments2 are to be copied over to worksheet B in the next available row since it is accumulative.

Comments and Comments2 are to be concatenated and copied as 1 field (Comment/Comment2) in Worksheet B.

Address and Remarks fields in Worksheet B will be manually filled up.

I’ve attached a sample of the excel file.

Hope it’s not too confusing but I can always further explain.

Greatly appreciate if anyone from here can help on this as I’m totally clueless.

Thanks a million! (Btw, I'm using MS Office 03)

Hello Sharonbl,

The attached workbook contains the macro shown below to copy the data from Worksheet A to Worksheet B.

Please Login or Register  to view this content.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross