How to consolidate two sheets of data?

**Christeen** · 11-20-2011, 08:21 PM

Hi,

I have a problem here. I don't have any idea how to duplicate records based on my master data kept in different work sheets. can anyone pls help?
pls refer to my attached file.

thanks in advanced.

note: output result pls refer to sheet "result(summary)"

**pike** · 11-21-2011, 12:36 AM

Hi Christeen

you try the classic combination using find

Please Login or Register  to view this content.

**royUK** · 11-21-2011, 02:41 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

You have posted this three times, and had a previous warning.

Thread Closed.