Related:
- How to paste automatically from another work
- Transfer data from one excel worksheet to another automatically - Guide
- How to automatically save photos from messenger to gallery - Guide
- Pc restarts automatically - Guide
- Download automatically while roaming - Guide
- How to open a web page automatically in full screen mode in html - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 28, 2012 at 09:18 AM
Feb 28, 2012 at 09:18 AM
Hi Basavaraj,
Your query is not clear to me.
But linking data between workbooks basicly works the same as between sheets.
Open both workbooks, type = in one workbooks cell and then select a cell from the other workbook. Formula's are apllied the same way.
If you need more help, then please explain your query in a more detailed matter.
Best regards,
Trowa
Your query is not clear to me.
But linking data between workbooks basicly works the same as between sheets.
Open both workbooks, type = in one workbooks cell and then select a cell from the other workbook. Formula's are apllied the same way.
If you need more help, then please explain your query in a more detailed matter.
Best regards,
Trowa
Hi,
As i understand, what u really want is.
sheet1 "H" column value need to add 1 when it come to Sheet2 "H" column and 2 need to add for sheet3. as below
Sheet1 H1=10 Sheet2 H1=11 & Sheet3 H1=12
so go to sheet2 H1 and type =sheet1!H1+1(or you can use = and go to sheet1 and then + 1)
In sheet3 H1 type =Sheet1!H1+2
In Sheet4 H1 type =Sheet1!H1+3
hope this is your requirement.
Rgrds
As i understand, what u really want is.
sheet1 "H" column value need to add 1 when it come to Sheet2 "H" column and 2 need to add for sheet3. as below
Sheet1 H1=10 Sheet2 H1=11 & Sheet3 H1=12
so go to sheet2 H1 and type =sheet1!H1+1(or you can use = and go to sheet1 and then + 1)
In sheet3 H1 type =Sheet1!H1+2
In Sheet4 H1 type =Sheet1!H1+3
hope this is your requirement.
Rgrds
