Spreadsheet merging problems

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?
 
M

mikkeltaylor

Joined
May 31, 2005
Messages
4
Reaction score
0
Quite new to this stuff but would suggest importing everything into Ms Access then letting they queries
do the rest.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing columns in two spreadsheets 1
Collate data from one spreadsheet into another spreadsheet 2
Updating worksheets from master worksheet based on column value 5
linking between spreadsheets 5
Extracting data from hyperlinked spreadsheets 3
SUMIF FUNCTION works in all cells but those related to one account 4
import data from several spreadsheets into one spreadsheet 2
Formula updates with SAVE AS 1

Top