Hello!
I am trying to set up my workbook so that information from the master page mirrors to a secondary page, based on specific criteria. (So I don't have to manually copy each column, and information changes on the master page reflect on the secondary pages).
For example, if the Master page, A14, says "E100" I want all of that information in the row to copy to the tab named "E100" and so on.
Is this even possible? If so, how do I set it up? I can't seem to figure out what logic to use.
Thank you in advance for any advice, even if it's "Duh, that's not possible", because I have been banging my head against this for a while now.
