How to paste automatically from another work

Closed
BASAVARAJ - Feb 26, 2012 at 11:06 PM
 sam - Jul 9, 2012 at 04:58 AM
Hello,
Dear Team,

i have a invoice format
how to paste automatically from another work book . if sheet 1 h
column 10 sheet 2 h column should be 11 sheet3 h column should be12
sheet 4 h column sholud be 13

NOT 10,12,13,14,15 ANY NUMBER FROM ANOTHER WORK BOOK.


Kindly send me the answer as soon as possible.


Regards,
Basavaraj

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
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
0
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
0