For reference you can see my first question and screen shot here: http://www.mrexcel.com/board2/viewtopic.php?t=183206
Okay, I've got my Work book working somewhat like I want. Now, how can I link info from 4 Worksheets to one Master Worksheet? So that when the info on Worksheet 1 changes, it automatically changes the info on the Master.
I've tried linking the rows using ='WS1"!7! and that doesn't work because of how I've got my rows switching around using the code from the above linked question. How do I get around this?
Okay, I've got my Work book working somewhat like I want. Now, how can I link info from 4 Worksheets to one Master Worksheet? So that when the info on Worksheet 1 changes, it automatically changes the info on the Master.
I've tried linking the rows using ='WS1"!7! and that doesn't work because of how I've got my rows switching around using the code from the above linked question. How do I get around this?