Loop and Extract data from 2 worksheets with varying rows of data

[quanweitkd]

Need help to create a macro to extract the following data (highlighted in green) from Multiple Worksheets onto the Summary sheet:

• Month of Report onto E1
• Date of Report onto E2
• Carpark ID on column D
• Carpark ID + Lane ID onto column E
• Percentages for Hourly, Season Parking and Total on column F, G, H respectively

Biggest problem I faced is different carparks have different number of entries and exits, hence the loop condition must be dynamic during the data extraction.

The summary sheet consists of 2 dates, one is for Wednesday and the other is for Saturday. So for my sample, 25 May (earlier date) there is one raw report and 28 may (later date) on a separate excel file. It is always extracted from the wed and sat raw reports.

The summary worksheet is manually created by me after the 2 raw reports are generated from the system. Hence need your help to extract data from the 2 dates raw data and paste them into the Summary sheet.

Data from 25 May will be populated into column E to H, whereas data from 28 May will be extracted onto column I to L on the Summary sheet.

Please download the sample file from here: Excel VBA Questions

Thank you!

 

[Legacy 143009]

I downloaded your files. Are Park No.s and Lane IDs always going to be fixed? No change from report to report?

 

[quanweitkd]

I downloaded your files. Are Park No.s and Lane IDs always going to be fixed? No change from report to report?

No change.

 

[Fluff]

Duplicate to: Need Help with VBA: Populate Data from Multiple Worksheets

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.