Use VBA to consolidate data from sheets 2 onwards into one new sheet called 'Master'

[webcam723]

Hi experts!

I am looking to use VBA to consolidate data from sheets 2 onwards into one new sheet called 'Master' to be placed in the second sheet position.

The data worksheets all have the same table format with data from Column A to T, I wish to only keep the header row (row 1) ONCE and start the data from row 2 onwards.

[wk9128]

Hi webcam723
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to.
Members tailor answers based on your Excel version. Your profile does not indicate your version 16.72.

Pls try this code

Please Login or Register  to view this content.

[webcam723]

For Each ws In ThisWorkbook.Sheets(2).Worksheets

In the above line of code, the error 'Object doesnt support this property or method' occurs.

[vcoolio]

Hello Webcam,

Create the Master sheet manually and place your required headings in row1, then try this simplified code:

Please Login or Register  to view this content.

There is no need to have a new sheet created each time the code is run. The above code clears the Master sheet each time that the code is run.

I hope that this helps.

Cheerio,
vcoolio.

[webcam723]

Hi thanks alot!

Ok so now my 'Master' sheet is the first sheet. I got another sheet in second position that I dont want to use the data from.

How can i edit the code such that it uses the 3rd sheet onwards?

[vcoolio]

Hello Webcam,

Just exclude the other sheet as well:

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.