Related:
- How to paste automatically from another work
- Transfer data from one excel worksheet to another automatically - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Pc automatically restarts - Guide
- How to insert picture in excel cell automatically from folder - Excel Forum
- Pc shuts down automatically after a few minutes ✓ - Hardware Forum
2 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
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