Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

How do I combine information from two spreadsheets into one?

Discussion in 'Information Technology' started by brin, Nov 15, 2005.

  1. brin

    brin
    Expand Collapse
    Guest

    My spreadsheets bot have the following rows:

    Dept. Description Merch. Cat. Description Taxware Product Code

    One spreadsheet has the several columns of company information and the other
    needs to have the items matched with the correct Dept. Descrp, Merch. Cat
    Descrp, and Tax Product code. However, I do not want to copy of paste the
    information by each new line on the new spreadsheet. How would I consolidate
    the two having the spreadsheet with the complete information carry over the
    information to the matching product on the new spreadsheet? Not every column
    will be listed in the new spreadsheet, so a search for like items will need
    to be conducted?
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    brin wrote:
    > My spreadsheets bot have the following rows:
    >
    > Dept. Description Merch. Cat. Description Taxware Product Code
    >
    > One spreadsheet has the several columns of company information and
    > the other needs to have the items matched with the correct Dept.
    > Descrp, Merch. Cat Descrp, and Tax Product code. However, I do not
    > want to copy of paste the information by each new line on the new
    > spreadsheet. How would I consolidate the two having the spreadsheet
    > with the complete information carry over the information to the
    > matching product on the new spreadsheet? Not every column will be
    > listed in the new spreadsheet, so a search for like items will need
    > to be conducted?


    Sorry. This is a newsgroup dedicated to questions about Access, the
    database program in Office Professional. It appears your question may not
    be related to these subjects. The Microsoft help system is not all that
    clear and may have misdirected you here.

    It is best to ask your questions in a newsgroup dedicated to the
    subject of your question. You should find people better able to address
    your problem there.

    Note: It is always best to indicate the name and version of any
    program(s) you may be using when asking a question and also indicate the
    operating system (like Windows XP or 98) when you ask a question.



    --
    Joseph Meehan

    Dia duit
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page