Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! Transfering files to Excel | Excel Worksheet Functions | |||
How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
Batch renaming of many worksheets in Excel files? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) |