I hope I don't get annoying with all my questions.

[JJRudd]

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?

 

[venkat1926]

did you try pastespecial-pastelinks.

 

[JJRudd]

..

 

[JJRudd]

How do you do that? Where do I put that formula so that it links the rows?

 

[venkat1926]

I am giving a trivial example
in sheet1--a1 is 2,B1 is 3 and c1=a1*b1
c1 will be 6
now select c1 edit -copy
goto sheet 2 A1
edit-pastepecial-pastelinks
now sheet2 A1 will also be 6
now change in sheet1 A1 and B1 and see what happens to A1 in sheeet2.

Ifyou get a hang ot it you can even prepare a macro.

 

[JJRudd]

That's not exactly what I was wanting.
Basically I've got rolling rows. A1 on sheet 1 = A5 on sheet 2. Then I change the info in A1 sheet 1 and it automatically sorts and become A5 sheet 1, and It becomes A15 sheet 2. I can't have A1=A1 because the info changes rows all the time. It may be A1=A5 at first but then all the info sorts and needs to become A7=A23.