Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying data between workbooks?
I am trying to link two documents.
In essence i have one document which will be updated regularly with information. I need to have a second document identical to the first (i.e. linked with = formulae), so as a user imputs information to spreadsheet A, it update the information in spreadsheet B automatically. The only way I can figure out to do this is individually clicking on destination cell, entering = , and then clicking on destination cell. Surely there is a way to do the whole document??? Any help is very gratefully accepted. Thanks |
#2
|
|||
|
|||
If the documents are identical in layout, you can do as you suggested in
your post for one cell, the copy that to the rest of the sheet. -- Ian -- "One Desperate Employee!" <One Desperate wrote in message ... I am trying to link two documents. In essence i have one document which will be updated regularly with information. I need to have a second document identical to the first (i.e. linked with = formulae), so as a user imputs information to spreadsheet A, it update the information in spreadsheet B automatically. The only way I can figure out to do this is individually clicking on destination cell, entering = , and then clicking on destination cell. Surely there is a way to do the whole document??? Any help is very gratefully accepted. Thanks |
#3
|
|||
|
|||
Thanks.
I have tried this. If i enter (=source cell) then this will duplicate cell in destination sheet, but when I copy and paste that cell it just duplicates that cell on the whole workbook. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 For example - If i enter formula to copy a1 on source (1(above)) then it will duplicate this in a1 on the destination. However when I copy and paste this i have a document full of 1's, rather than all the different values. Does that make sense? "Ian" wrote: If the documents are identical in layout, you can do as you suggested in your post for one cell, the copy that to the rest of the sheet. -- Ian -- "One Desperate Employee!" <One Desperate wrote in message ... I am trying to link two documents. In essence i have one document which will be updated regularly with information. I need to have a second document identical to the first (i.e. linked with = formulae), so as a user imputs information to spreadsheet A, it update the information in spreadsheet B automatically. The only way I can figure out to do this is individually clicking on destination cell, entering = , and then clicking on destination cell. Surely there is a way to do the whole document??? Any help is very gratefully accepted. Thanks |
#4
|
|||
|
|||
Assuming your source sheet is Sheet1, A1 on your destination sheet should
read =Sheet1!A1. Copying this to B1 will return =Sheet1!B1 etc. -- Ian -- "One Desperate Employee!" wrote in message ... Thanks. I have tried this. If i enter (=source cell) then this will duplicate cell in destination sheet, but when I copy and paste that cell it just duplicates that cell on the whole workbook. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 For example - If i enter formula to copy a1 on source (1(above)) then it will duplicate this in a1 on the destination. However when I copy and paste this i have a document full of 1's, rather than all the different values. Does that make sense? "Ian" wrote: If the documents are identical in layout, you can do as you suggested in your post for one cell, the copy that to the rest of the sheet. -- Ian -- "One Desperate Employee!" <One Desperate wrote in message ... I am trying to link two documents. In essence i have one document which will be updated regularly with information. I need to have a second document identical to the first (i.e. linked with = formulae), so as a user imputs information to spreadsheet A, it update the information in spreadsheet B automatically. The only way I can figure out to do this is individually clicking on destination cell, entering = , and then clicking on destination cell. Surely there is a way to do the whole document??? Any help is very gratefully accepted. Thanks |
#5
|
|||
|
|||
That is correct. I've just figured it out from your post. For some reason my
destination sheet was reading =sheet1!$A$1. Not sure why. Any ideas?? Anyway after reading your post and taking out the $ signs it works perfectly. Thank you for your help - you are a superstar!!! "Ian" wrote: Assuming your source sheet is Sheet1, A1 on your destination sheet should read =Sheet1!A1. Copying this to B1 will return =Sheet1!B1 etc. -- Ian -- "One Desperate Employee!" wrote in message ... Thanks. I have tried this. If i enter (=source cell) then this will duplicate cell in destination sheet, but when I copy and paste that cell it just duplicates that cell on the whole workbook. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 For example - If i enter formula to copy a1 on source (1(above)) then it will duplicate this in a1 on the destination. However when I copy and paste this i have a document full of 1's, rather than all the different values. Does that make sense? "Ian" wrote: If the documents are identical in layout, you can do as you suggested in your post for one cell, the copy that to the rest of the sheet. -- Ian -- "One Desperate Employee!" <One Desperate wrote in message ... I am trying to link two documents. In essence i have one document which will be updated regularly with information. I need to have a second document identical to the first (i.e. linked with = formulae), so as a user imputs information to spreadsheet A, it update the information in spreadsheet B automatically. The only way I can figure out to do this is individually clicking on destination cell, entering = , and then clicking on destination cell. Surely there is a way to do the whole document??? Any help is very gratefully accepted. Thanks |
#6
|
|||
|
|||
Are your sheets in different workbooks? I notice that copying from a
different book gives eg =[Book2]Sheet1!$A$1 but copying from another sheet in the same book gives =Sheet2!A1 -- Ian -- "One Desperate Employee!" <One Desperate wrote in message ... That is correct. I've just figured it out from your post. For some reason my destination sheet was reading =sheet1!$A$1. Not sure why. Any ideas?? Anyway after reading your post and taking out the $ signs it works perfectly. Thank you for your help - you are a superstar!!! "Ian" wrote: Assuming your source sheet is Sheet1, A1 on your destination sheet should read =Sheet1!A1. Copying this to B1 will return =Sheet1!B1 etc. -- Ian -- "One Desperate Employee!" wrote in message ... Thanks. I have tried this. If i enter (=source cell) then this will duplicate cell in destination sheet, but when I copy and paste that cell it just duplicates that cell on the whole workbook. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 For example - If i enter formula to copy a1 on source (1(above)) then it will duplicate this in a1 on the destination. However when I copy and paste this i have a document full of 1's, rather than all the different values. Does that make sense? "Ian" wrote: If the documents are identical in layout, you can do as you suggested in your post for one cell, the copy that to the rest of the sheet. -- Ian -- "One Desperate Employee!" <One Desperate wrote in message ... I am trying to link two documents. In essence i have one document which will be updated regularly with information. I need to have a second document identical to the first (i.e. linked with = formulae), so as a user imputs information to spreadsheet A, it update the information in spreadsheet B automatically. The only way I can figure out to do this is individually clicking on destination cell, entering = , and then clicking on destination cell. Surely there is a way to do the whole document??? Any help is very gratefully accepted. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to use data from different workbooks in formulas? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Consolidate data from several workbooks | Excel Worksheet Functions | |||
Linking WorkBooks Based on Data Entered In One of Them | Excel Discussion (Misc queries) | |||
Merging data from several workbooks | Excel Worksheet Functions |