Ask Experts Questions for FREE Help !
Ask

compare data in three sheets to find matches and copy matches to a fourth sheet

Asked Apr 27, 2012, 01:57 PM — 1 Answer
I am working with an excel workbook that contains three sheets with a vast amount of data. I need to find data on sheets 1 and 2 that match sheet 3 then have the matching data entered onto sheet 4 (a new sheet).

Is there a function or a code that will allow me to do this, as cross referencing these sheets could take many hours as there is over 33000 entries.

Search this Thread
Share |
1 Answer
JBeaucaire's Avatar
JBeaucaire Posts: 5,373, Reputation: 5036
Software Expert
  
#2

Apr 27, 2012, 11:29 PM


If you want to post up a smaller excerpt of the main sheet with some sample data on sheets 1, 2 and 3 and a manual mockup of the expected results on sheet 4 from that sample, I'm sure I can help.

This can be probably be done on Sheet3 using formulas only and an Autofilter, so sheet4 wouldn't really be needed.

Or it can be done with VBA to sheet4.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Compare related data stored in two or more excel sheets [ 18 Answers ]

How to compare related data stored in two or more different excel sheets? For example, annual sales figure of a number of companies relating to two OR more years available in different excel sheets? Either by grouping (pooling) the data into a single excel sheet or otherwise?

Ballistics matches on bullets [ 1 Answers ]

If bullets are retrieved from a murder scene, but no gun is found, can ballistics determine that the bullets match bullets used in another crime? Is this type of information computerized so bullets can be compared or do they have to be compared separately under a microscope?

Sorting & highlighting exact matches [ 4 Answers ]

I am working with a very large spreadsheet. I need to sort it by one column to find items that have the exact same number assigned to them. Is there a way to do this where those matches are highlighted so that they stand out? I have sorted by this column, but it will take me days to scroll...

What color matches with my hair [ 2 Answers ]

I have very balck hair, it falls a lot so I don't have a lot of it. My hair is weak and dry just a little. I want to make it brown for a change. Is it better just to high light it to prevet having more hair fall & dry hair. Or is it better to dye it all ?:confused:

Which Canadate matches your views? [ 3 Answers ]

Pick Your Candidate Pretty Interesting site. Any surprises?

View more Spreadsheets questions Search