Linking Tabs

[amrinaldi]

I am wondering if it is possible to link tabs? I have a master spreadsheet that I edit and adjust the fields daily. Is there a way to mirror separate tabs to reflect the changes made in the master spreadsheet? I will be adjusting two fields mostly, one is a drop down menu with several options(approved, revise & resubmit, acknowledged) and the other is the date. Is there a way that when I change the status in the master list that a separate tab will capture that change and populate into a row on that tab?

Thanks for any and all help.

[natefarm]

Put this in the code module for the master worksheet, and adjust the column # and destination sheet name as needed.

Please Login or Register  to view this content.