Import data from another sheet that matches to a class list?

G

gmac70

I am trying to import/merge data from another workbook. The data needs to
match up to a like list (ie. a class list). Can this be done automatically as
oppose to copy and paste and then check the list of names?
 
G

gmac70

Thank you in advance.

I have a sheet containing a class list with data next to their name. I would
like to merge some data from another sheet but it needs to tally up with the
same names in both books.

Is there a way I can import it without copy and paste and then have to check
each entry matches? i.e. Name of child - Spring Grade. Can I import into
another column the summer grades?

Hope this makes sense?

Thanks
 
D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.

I'll take a look tomorrow
 

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

Merging from an Excel file with graphics 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Dumb question alert! What program to use? 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Publisher is filling blank lines with data 2
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top