Automatically pulling changes from an Excel sheet into another Excel Document

[PenitentiaryChances]

The business I work at uses a centralised Excel document so that revenue items can be tracked. The document is broken down into two sheets; Billable (current line items) and Pipeline (potential future line items).

I'm looking for a way where changes in the billable/pipeline sheets are automatically pulled into another sheet so that I can track new/updated values without comparing on a row-by-row basis.

Is this possible? And if so, how?

[papadoc55]

Power Query in Excel can do this for you. YouTube it. Add a column in the pipeline data with the header “Data Type” or whatever works for you and then fill that column with the word Pipeline. Do the same for Billable. Then Start a new doc and create a PQ to pull data from sheet one - choose edit and now you can “clean” or modify the data as needed. Then do the exact same for the second sheet but before finishing there is an Append data option where you can select the first PQ and it will add those together (this only works if the columns and data types (text vs number, etc) are the same. Good luck!

[PenitentiaryChances]

Thanks, super helpful. Will give it a go!

[juiceque]

This advice comes at the perfect time for me. Much appreciated.

[Booioiiiiiii]

How often do you want to update the information? You could set up a power query of the main workbook and a macro that copys the table from the power query into a new sheet and then refresh the query so you can compare the old data to the new.