Removing Intermediary Connections


F

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!
 
Ad

Advertisements

D

Don Guillett

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

Advertisements

F

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top