How do I combine information from two spreadsheets into one?

B

brin

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine two spreadsheets into one 3
How do I combine information from two separate spreadsheets 2
How do I consolidate data from several spreadsheets into one. 4
Comparing two spreadsheets with pricing information 5
Combining two tables with no matching field name 8
Combining two spreadsheets. 5
filters don't work after combining several spreadsheets into one 3
Need an example of importing from Excel to Access 3

Top