Let me start by saying, this is probably not the easiest way to do this, but I am in networking, so here we are.
I am looking for a way to mark the rows in the master sheet (either with a value (Active or Completed) or a check box) to retain the row in the master sheet even after a removal from one of the inventory (feeder) sheets.
Actual Problem:
Upon a request from management, a new sheet was created to combine the inventory and planning into one location in hopes that it would make it easier (there is a whole back story to this). After many attempts, we settled on PowerQuery to create a master sheet to combine all of the inventory of the different types of equipment. This part works great. Also, we added columns for management to keep track of the planning portion (cost estimates, dates, etc). This was done with another query (connection only and unique key) to keep the rows in line. This also works great.
So, what is the problem? As we replace equipment, it will be deleted from the inventory sheets and therefore deleted from the master sheet, changing counts, cost estimates, and deleting any project information added in the master sheet. We are trying to keep the cost estimates for many fiscal years for comparison and tracking.
Poor planning on our part? Possibly, but that's what you get when you ask networking to create spreadsheets.
Please keep in mind that I am not a programmer, so saying "Use VBA" will require more detail. Also, while I am an excel junkie, I am new to the PowerQuery side of the world and I am pretty sure that I am doing all sorts of things incorrectly - but it's working.
Short of a copy/paste of the rows to an archive before they are deleted, any insight is appreciated.
Thanks In Advance!
I am looking for a way to mark the rows in the master sheet (either with a value (Active or Completed) or a check box) to retain the row in the master sheet even after a removal from one of the inventory (feeder) sheets.
Actual Problem:
Upon a request from management, a new sheet was created to combine the inventory and planning into one location in hopes that it would make it easier (there is a whole back story to this). After many attempts, we settled on PowerQuery to create a master sheet to combine all of the inventory of the different types of equipment. This part works great. Also, we added columns for management to keep track of the planning portion (cost estimates, dates, etc). This was done with another query (connection only and unique key) to keep the rows in line. This also works great.
So, what is the problem? As we replace equipment, it will be deleted from the inventory sheets and therefore deleted from the master sheet, changing counts, cost estimates, and deleting any project information added in the master sheet. We are trying to keep the cost estimates for many fiscal years for comparison and tracking.
Poor planning on our part? Possibly, but that's what you get when you ask networking to create spreadsheets.
Please keep in mind that I am not a programmer, so saying "Use VBA" will require more detail. Also, while I am an excel junkie, I am new to the PowerQuery side of the world and I am pretty sure that I am doing all sorts of things incorrectly - but it's working.
Short of a copy/paste of the rows to an archive before they are deleted, any insight is appreciated.
Thanks In Advance!
