Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Intermediary Connections
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Connections | Excel Worksheet Functions | |||
Data connections | Excel Discussion (Misc queries) | |||
Managing ODBC connections | Excel Discussion (Misc queries) | |||
remote connections | New Users to Excel | |||
dynamic connections in excel? | Excel Worksheet Functions |