Removing Intermediary Connections

[FARAZ QURESHI]

I have around three sheets between the source and the output sheets. In other
words, lets take an "EXAMPLE" as:

1. Sheet1!A1 is the source cell;
2. Sheet2!B1 = Sheet1!A1*1000;
3. Sheet3!C2 = Sheet2!B1/2;
4. Sheet4!S2 is the output cell which = Sheet3!C2-2;

Is there any code to have the following results:

1. Sheet2!B1 = (Sheet1!A1)*1000;
2. Sheet3!C2 = (Sheet1!A1*1000)/2; and
3. Sheet4!S2 = (Sheet1!A1*1000/2)-2

Your help and guidance or even a reference to a related/similar source on
net shall be obliged!

Thanx in advance!

 

[Don Guillett]

When you say code, I guess you want a macro. Use this ideasheets("Sheet2").range("b1").value=sheets("sheet1").range("a1")*1000

 

[FARAZ QURESHI]

No doubt a macro would obviously be the only way out, but what I presented
was just an example. The main theme is to have all the final cells, no matter
wherever the same are placed/addressed, to be 'directly' referring to the
source cells whichever they might be.

Any idea?
--

Best Regards,
FARAZ A. QURESHI

When you say code, I guess you want a macro. Use this ideasheets("Sheet2").range("b1").value=sheets("sheet1").range("a1")*1000