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

JJRudd

New Member
Joined
Dec 6, 2005
Messages
34
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?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

JJRudd

New Member
Joined
Dec 6, 2005
Messages
34
How do you do that? Where do I put that formula so that it links the rows?
 

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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

New Member
Joined
Dec 6, 2005
Messages
34
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,450
Messages
5,572,181
Members
412,447
Latest member
immy
Top