CONSOLIDATE ALL SHEETS DATA IN NEW SHEET 1 FIELD (1 Viewer)

[georg0307]

Dear All.

could you please hlp me?

I need to aggregate all sheets data (the same for all A:A) in a new sheet, so that I obtain a unique field with all data.

Thanks in advance

Georg

 

[Gasman]

Is this a regular requirement?, as a quick copy and paste would be the best way if not.?

Else look at moving through all worksheets
https://www.google.com/search?q=vba...j0i22i30l6.10511j0j4&sourceid=chrome&ie=UTF-8

Finding last line of data
https://www.google.com/search?sxsrf...pgBAKABAaoBB2d3cy13aXrIAQjAAQE&sclient=psy-ab

Setting range with a variable
https://www.google.com/search?q=set...2j0i22i30l7.7133j0j9&sourceid=chrome&ie=UTF-8

HTH

 

[georg0307]

Hi,
at the end of the year there will be a lot sheets (1 per day), the column A:A is the same for all sheets.

it will be regular equirement.

Thanks in advance for prompt answer


Georg

 

[Gasman]

FWIW with Excel, at least you can use the macro recorder to start with the basic code, then modify to suit.?

That is how I learnt a lot of my Excel plus Googling of course.

You also need to check your data as it is not all just numbers?

 

[arnelgp]

for test, use Test.xlsm
on the ribbon->Home, there is a Custom Group (Consolidate).
click this button and click on the Sheet where you want to save
the consolidated result.