Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help to import data from reference workbook
I wasn't sure if this would require VB or not so I've put this in the
General Question group. I have 2 workbooks where the first 3 columns of each row (after a title row) consist of an ID number, a North coordinate and an East Coordinate. Workbook A is complete in that every ID for our system is included along with the coresponding North and East coords. Workbook B includes a subset of the IDs and only some of the IDs have their coords in columns B and C. How do I import the coords into Workbook B without having to copy/paste a thousand or more times. Thanks in advance for any help. |
#2
|
|||
|
|||
Hi!
With both workbooks open you could use a Vlookup formula to get the data from fileA to fileB. Then after that was completed you could convert the formulas to constants. Assume data in fileA is on Sheet1 in the range A2:C100 ID's in fileB are on Sheet1 in the range A2:A50 In B2 of fileB use a formula like this: =VLOOKUP($A2,[fileA.xls]Sheet1!$A$2:$C$100,COLUMN(B$1),0) Copy across to C2 then down as needed. Once all the data is returned and you're satisfied, select fileB columns B and C and then do copy/paste special/values. Biff "JackSpam" wrote in message ... I wasn't sure if this would require VB or not so I've put this in the General Question group. I have 2 workbooks where the first 3 columns of each row (after a title row) consist of an ID number, a North coordinate and an East Coordinate. Workbook A is complete in that every ID for our system is included along with the coresponding North and East coords. Workbook B includes a subset of the IDs and only some of the IDs have their coords in columns B and C. How do I import the coords into Workbook B without having to copy/paste a thousand or more times. Thanks in advance for any help. |
#3
|
|||
|
|||
Thanks so much for the help. In hind sight it was so simple. I ended up expanding the vlookup function to integrate 3 columns and still had time for a morning bike ride before temps hit 100. Take care. "Biff" wrote: Hi! With both workbooks open you could use a Vlookup formula to get the data from fileA to fileB. Then after that was completed you could convert the formulas to constants. Assume data in fileA is on Sheet1 in the range A2:C100 ID's in fileB are on Sheet1 in the range A2:A50 In B2 of fileB use a formula like this: =VLOOKUP($A2,[fileA.xls]Sheet1!$A$2:$C$100,COLUMN(B$1),0) Copy across to C2 then down as needed. Once all the data is returned and you're satisfied, select fileB columns B and C and then do copy/paste special/values. Biff "JackSpam" wrote in message ... I wasn't sure if this would require VB or not so I've put this in the General Question group. I have 2 workbooks where the first 3 columns of each row (after a title row) consist of an ID number, a North coordinate and an East Coordinate. Workbook A is complete in that every ID for our system is included along with the coresponding North and East coords. Workbook B includes a subset of the IDs and only some of the IDs have their coords in columns B and C. How do I import the coords into Workbook B without having to copy/paste a thousand or more times. Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data using macro | Excel Discussion (Misc queries) | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Import Data into same cell | Excel Discussion (Misc queries) | |||
Import Excel Data from another workbook or file | Excel Discussion (Misc queries) | |||
Automatic Data Import | Excel Discussion (Misc queries) |