ExcelBanter - Removing Intermediary Connections

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Removing Intermediary Connections (https://www.excelbanter.com/excel-discussion-misc-queries/214883-removing-intermediary-connections.html)

Removing Intermediary Connections

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!

--

Best Regards,
FARAZ A. QURESHI

Removing Intermediary Connections

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

"Don Guillett" wrote:

When you say code, I guess you want a macro. Use this idea
Sheet2!B1 = (Sheet1!A1)*1000;
sheets("Sheet2").range("b1").value=sheets("sheet1" ).range("a1")*1000

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FARAZ QURESHI" wrote in message
...
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!

--

Best Regards,
FARAZ A. QURESHI