Hi all.
In the "central" worksheet, I would like to centralize contents from each worksheet. An example is in the file.
The worksheets have the calendar date in their name. Any ideea? thx in advance.
Hi all.
In the "central" worksheet, I would like to centralize contents from each worksheet. An example is in the file.
The worksheets have the calendar date in their name. Any ideea? thx in advance.
This proposal employs Get & Transform (Power Query) found on the Data tab.
First step is to copy the column headers from the "central" sheet and paste them in the daily sheet.
Next step is to produce a table from the data on each sheet. I only included the rows that actually had data in column B and to the right.
Next step is to name the table. I used tbl_01072019 etc.
Next step, from the data tab choose From Table/Range and paste the following in the advanced editor window:
Next step is to select Close and Load to... from the home tab of the power query editor window.Please Login or Register to view this content.
Repeat the above steps for each sheet you want to include in the Central table, changing the name tbl_01072019 and the #"Added Custom" = Table.AddColumn(#"Changed Type", "Data", each "01.07.2019"), as needed.
Next step is to select Get Data from Data tab then choose combine queries then select append then three or more tables then select all tables you want in the Central table and select OK.
Next step is to give the new table a name then select Close & Load at which point Excel will put the table on a new sheet (1 in the attached copy of the file).
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks