+ Reply to Thread
Results 1 to 6 of 6

Combine two spreadsheets with Different column headings

  1. #1
    Angela
    Guest

    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. #2
    Gord Dibben
    Guest

    Re: 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 <[email protected]>
    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. #3
    Angela
    Guest

    Re: 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 <[email protected]>
    > 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. #4
    Gord Dibben
    Guest

    Re: 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 <[email protected]>
    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 <[email protected]>
    >> 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. #5
    Angela
    Guest

    Re: 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 <[email protected]>
    > 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 <[email protected]>
    > >> 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. #6
    Otto Moehrbach
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    > 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
    >> <[email protected]>
    >> 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1