Spreadsheet merging problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Quite new to this stuff but would suggest importing everything into Ms Access then letting they queries
do the rest.
 
Back
Top