Good afternoon, all!
I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management.
I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull this information into 5-8 other sheets to ensure that each division has access to their specific information.
Using reports was my original plan, but the divisions will need the ability to customize what they want to see on those reports and the inability to save filters for quickly needed pulls isn't going to work.
I used INDEX/MATCH formulas to create individual divisional sheets that pulled the information, but I ran into a snag with changes. I would love to be able to add and remove rows on my master sheet and have the secondary sheets follow suit. However, this seems to be impossible. I can't get the copy rows automaton to match locations from one sheet to the next (it always goes to the bottom).
So, my question is, has anyone found a way to add and remove rows automatically as updates are made to the primary data sheet? If this is better done through other functionality I am all for learning.
Thank you!
