Forum Discussion
migrating data from one sheet to another
- Have both files open. (I'm assuming the data in both files are organized in columns, and adjacent columns in File-B)
- In File-A start writing a VLOOKUP formula, by entering in a cell next to the SKU column of File-A, the following =VLOOKUP(A2, [this is assuming that the first SKU is in cell A2; we'll end up copying the formula down all 1200 rows]
- Then keeping that formula open, move to File-B and highlight and select the columns containing SKU and Price, such that in File-A, the formula now reads something like
- =VLOOKUP(A2,[File-B.xls]worksheet1!A2:B2000,
- And then add to the formula so that it ends looking something like:
- =VLOOKUP(A2,[File-B.xls]worksheet1!A2:B2000,2,0)
- And copy that formula down all 1,200 rows in File-A
If that doesn't work (I've created those from memory, not actually testing them in Excel, but do have formulas like that in some of my own multi-workbook files)....if that doesn't work, please upload your actual spreadsheets so we can work with the actual files. Or some representative samples (50 rows and 200 rows in A and B respectively)
I agree with mathetes procedure, in addition to the formula at step 6 which is
=VLOOKUP(A2,[File-B.xls]worksheet1!A2:B2000,2,0), before you copy this formula down to the remaining 1199 rows you need to fix the formula so the range values are fixed and will not transpose which is =VLOOKUP(A2,[File-B.xls]worksheet1!$A$2:$B$2000,2,0).
By adding a $ sign with the range value, this ensures that the range is fixed for all 1199 rows.
