Combining files in Excel
 

2 simple things that i can't seem to do
#1 have 2 spreadsheets - no formulas - both spreadsheets have same column
headers ; need to paste contents of one at the bottom of the other; get the
error that the paste area is a different size than the copy area. How can I
add these rows to my spreadsheet?

#2 once that's done, have a third file'; third file has member id (common to
both files) want to match those people who are in thir file to those in first
and pull a field (email) from third file and put it on the record in the
first...
Thanks

Combining files in Excel
 

Copy the data from spreadsheet 1, click on the next spreadsheet, click on a
cell you want and paste.

You could sort the entire list and use filters to pull the emails.

"Lauri" wrote:

2 simple things that i can't seem to do
#1 have 2 spreadsheets - no formulas - both spreadsheets have same column
headers ; need to paste contents of one at the bottom of the other; get the
error that the paste area is a different size than the copy area. How can I
add these rows to my spreadsheet?

#2 once that's done, have a third file'; third file has member id (common to
both files) want to match those people who are in thir file to those in first
and pull a field (email) from third file and put it on the record in the
first...
Thanks

Combining files in Excel
 

You can also use VLOOKUP to bring in the e-mail address since the member id
is common to both spreadsheets.
--
Elisabeth


"E10" wrote:

Copy the data from spreadsheet 1, click on the next spreadsheet, click on a
cell you want and paste.

You could sort the entire list and use filters to pull the emails.

"Lauri" wrote:

2 simple things that i can't seem to do
#1 have 2 spreadsheets - no formulas - both spreadsheets have same column
headers ; need to paste contents of one at the bottom of the other; get the
error that the paste area is a different size than the copy area. How can I
add these rows to my spreadsheet?

#2 once that's done, have a third file'; third file has member id (common to
both files) want to match those people who are in thir file to those in first
and pull a field (email) from third file and put it on the record in the
first...
Thanks