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

[blsoh]

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)

 

[blsoh]

hi there, just wondering if anyone has any clue for this? thanks

 

[DeanRowe]

maybe there has been no response because this is an Access forum and not Excel.