Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two spreadsheets with Different column headings
How do I combine two spreadsheets of contacts and make one spreadsheet
conform to the structure of the other. Both sheets have the same data type, but I don't want to have to cut and paste and move columns around in the sheet or delete unwanted columns in the sheet. Is there a way that I can just bring them together and have the one format itself to the other? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two spreadsheets with Different column headings
Angela
"Spreadsheets" are two workbooks or two worksheets in one workbook? I, for one, would need more detail on what your layout is on each sheet before attempting any advice. Different column headings may pose a problem but no way to know. Gord Dibben Excel MVP On Thu, 8 Dec 2005 12:46:02 -0800, Angela wrote: How do I combine two spreadsheets of contacts and make one spreadsheet conform to the structure of the other. Both sheets have the same data type, but I don't want to have to cut and paste and move columns around in the sheet or delete unwanted columns in the sheet. Is there a way that I can just bring them together and have the one format itself to the other? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two spreadsheets with Different column headings
OK - the one worksheet is an Outlook export of contacts. The other worksheet
in a different file is contacts that i use to just do mailing so i don't need all of the columns that are in the Outlook sheet. In addition, I have changed column names. So out of the 20 or so columns in the Outlook export, I only need about 8 - so when I copy contacts from the Outlook export, I want it to just go in to the columns as I have it set it on the second worksheet. "Gord Dibben" wrote: Angela "Spreadsheets" are two workbooks or two worksheets in one workbook? I, for one, would need more detail on what your layout is on each sheet before attempting any advice. Different column headings may pose a problem but no way to know. Gord Dibben Excel MVP On Thu, 8 Dec 2005 12:46:02 -0800, Angela wrote: How do I combine two spreadsheets of contacts and make one spreadsheet conform to the structure of the other. Both sheets have the same data type, but I don't want to have to cut and paste and move columns around in the sheet or delete unwanted columns in the sheet. Is there a way that I can just bring them together and have the one format itself to the other? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two spreadsheets with Different column headings
In master Outlook Contacts sheet(the one with 20 columns) hide the columns you
don't want then select visible cells only and copy those over to the smaller sheet with the 8 columns? Gord On Thu, 8 Dec 2005 13:41:02 -0800, Angela wrote: OK - the one worksheet is an Outlook export of contacts. The other worksheet in a different file is contacts that i use to just do mailing so i don't need all of the columns that are in the Outlook sheet. In addition, I have changed column names. So out of the 20 or so columns in the Outlook export, I only need about 8 - so when I copy contacts from the Outlook export, I want it to just go in to the columns as I have it set it on the second worksheet. "Gord Dibben" wrote: Angela "Spreadsheets" are two workbooks or two worksheets in one workbook? I, for one, would need more detail on what your layout is on each sheet before attempting any advice. Different column headings may pose a problem but no way to know. Gord Dibben Excel MVP On Thu, 8 Dec 2005 12:46:02 -0800, Angela wrote: How do I combine two spreadsheets of contacts and make one spreadsheet conform to the structure of the other. Both sheets have the same data type, but I don't want to have to cut and paste and move columns around in the sheet or delete unwanted columns in the sheet. Is there a way that I can just bring them together and have the one format itself to the other? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two spreadsheets with Different column headings
OK - thank you so much Gord. That sounds like it will work just fine. How
do you select visible cells only? "Gord Dibben" wrote: In master Outlook Contacts sheet(the one with 20 columns) hide the columns you don't want then select visible cells only and copy those over to the smaller sheet with the 8 columns? Gord On Thu, 8 Dec 2005 13:41:02 -0800, Angela wrote: OK - the one worksheet is an Outlook export of contacts. The other worksheet in a different file is contacts that i use to just do mailing so i don't need all of the columns that are in the Outlook sheet. In addition, I have changed column names. So out of the 20 or so columns in the Outlook export, I only need about 8 - so when I copy contacts from the Outlook export, I want it to just go in to the columns as I have it set it on the second worksheet. "Gord Dibben" wrote: Angela "Spreadsheets" are two workbooks or two worksheets in one workbook? I, for one, would need more detail on what your layout is on each sheet before attempting any advice. Different column headings may pose a problem but no way to know. Gord Dibben Excel MVP On Thu, 8 Dec 2005 12:46:02 -0800, Angela wrote: How do I combine two spreadsheets of contacts and make one spreadsheet conform to the structure of the other. Both sheets have the same data type, but I don't want to have to cut and paste and move columns around in the sheet or delete unwanted columns in the sheet. Is there a way that I can just bring them together and have the one format itself to the other? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two spreadsheets with Different column headings
Angela
Let's call one file Outlook and the other file Other. You say you want some of the data from the Outlook sheet copied to the Other sheet. First off, copy the sheet from Outlook file to the Other file. That's easier to work with and you can always delete the Outlook sheet later. Now tell us what you want with specifics. Something like : Copy column A from Outlook to column D of Other. Copy column E of Outlook to column B of Other. And so forth. And so forth. Once we have that it is no problem to write you a macro procedure to do what you want. HTH Otto "Angela" wrote in message ... OK - the one worksheet is an Outlook export of contacts. The other worksheet in a different file is contacts that i use to just do mailing so i don't need all of the columns that are in the Outlook sheet. In addition, I have changed column names. So out of the 20 or so columns in the Outlook export, I only need about 8 - so when I copy contacts from the Outlook export, I want it to just go in to the columns as I have it set it on the second worksheet. "Gord Dibben" wrote: Angela "Spreadsheets" are two workbooks or two worksheets in one workbook? I, for one, would need more detail on what your layout is on each sheet before attempting any advice. Different column headings may pose a problem but no way to know. Gord Dibben Excel MVP On Thu, 8 Dec 2005 12:46:02 -0800, Angela wrote: How do I combine two spreadsheets of contacts and make one spreadsheet conform to the structure of the other. Both sheets have the same data type, but I don't want to have to cut and paste and move columns around in the sheet or delete unwanted columns in the sheet. Is there a way that I can just bring them together and have the one format itself to the other? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
how do I get infopath elements as column headings in excel xml lis | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
move column headings from row to column | Excel Worksheet Functions | |||
pivot table row vs column headings | Excel Worksheet Functions |