Import/Merge Selected Data

H

Hanson

I have a data list (file A) in excel that was imported from a query in a non-Microsoft program. I need to have data based on certain paramenter from that excel file (File A) imported?/merged? into a worksheet in another excel file (file B) in a specific area. The worksheet in File B is a formatted worksheet. There are 5 sections in the formatted worksheet.

How do I get specific data from file A imported(merged?) into a specific section of the worksheet in File B?

Example: Import/merge only category 4A names and grades from File A into section 4A of the worksheet in File B. Then the same for category 5A items.
 

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

Formating bolded text exclusively. 0
Creating a Chart on form from selected data in query. 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Excel 2013 Merge Data 2
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Help with cell referencing. 0
merging data/worksheets 1
sorting noncontiguous data with exceptions 3

Top