Spreadsheet cumulative

Good Morning !
guys, how can I assemble a worksheet that accumulates other worksheets in one in excel?

I have countless spreadsheets generated daily in this format, and at the end of the day, I want to consolidate the information from those spreadsheets into a new spreadsheet.

Hey @Luan

At every end of the day,

  1. You can get all the child excel files

  2. Iterate the files & read it to use Append Range which keeps on appending the data to the Master Excel from the daily generated files

Hope this helps


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.