Hi
I am not sure if there is a formula or some other way to copy info from one workbook to another.
I have attached the 2 workbooks i am using. What i need to do is insert the prices from the 'prices' spreadsheet into the 'to be priced' spreadsheet.
On the 'to be priced' spreadsheet there could be several rows with the same part number. These will need to be brought across from the priced spreadsheet and inserted into column G on the 'to be priced' matching the part number. Is there anyway i can link the part numbers from each workbook and put the appropriate price into the 'to be priced' workbook?
Prices.xlsx
To be priced.xlsx
I hope this makes sense
Bookmarks