Automating Inventory Updates Across Multiple Sheets

**dolzon** · 05-20-2022, 11:56 AM

Hi,

I manage a solution design reference excel document in order to manage web analytic features. As of the moment, this reference document has become to complex to manage manually. Therefore, I'm looking to automate updates that happen between 2 separate sheets within an excel file.

While I know what I want the document to do, I'm not aware of the terminology or methods to search for that would best help me solve this problem.

For more information about my scenario, please see the screenshot below.

Thanks in advance!

Screenshot 2022-05-19 165734.jpg

**AliGW** · 05-26-2022, 02:58 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.