Spreadsheet merging problems
I have a number of spreadsheets that I need to merge. I have a master
spreadsheet with 37 columns of data required. On the other spreadsheets there is a common field on each with the master spreadsheet. Is there any formula that I can use which tells excel to look at the two spreadsheets and for example if column A on spreadsheet one matches column A on spreadsheet 2 then import the information from column D on spreadsheet 2 into colum J on spreadsheet 1? |
All times are GMT +1. The time now is 08:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com