Thread: How to consolidate data - easy?

I have two worksheets and need to consolidate the relevant data into one worksheet.

On both worksheets there is one column that I can relate to the other worksheet, called "TKR", which contains a code in each field, such as
"000210 K", or "004170KS". Both worksheets have this column. In the first worksheet, called POS, each "TKR" code tells me that this is a relevant "TKR" code in the DB worksheet. I am not interested in the data in POS, just the code to tell me which records are relevant in DB.

In DB is the information I need to extract. But in this worksheet, there are many irrelevant records, which I need to ignore. I need to reference the data in the TKR column in the POS worksheet with the data in the TKR column of the DB worksheet, then extract the record from the DB worksheet and place it in a new worksheet, along with each other extracted record, compiling a consolodated list. I could do this by cut and paste, but I have 30 different databases, both POS and DB, each containing up to 6000 records.

In the POS worksheet there is more than one record for each "TKR" code. I can run an Advanced Filter to extract a consolidated list of "TKR" codes. I am stumped however on how to then use that list to reference the same codes in the DB worksheet and extract the records to a new sheet.

If anyone can help I would be extremely grateful!

Hi,

It would be better if you could post a sample of your workbook just to show us what you mean exactly and how you want the outcome to look

Sorry Stretch, no file..

Hi Stretch,
please avoid this in the future as per forum rules..