Extract of line items or entries having unique *6 digit ref* - using Macro VBA

Hi Excel experts,

I was trying to extract only those entries, which has a unique 6 digit reference, in their description. Ex: *123456*

As, the number of such entries & with entries not having the unique reference (orange colored) are more, totals to 350. Looking for a Macro to do this task.

One requirement - there are 3 kind of line tems with unique ref- having corporation, R.B.O.S & Barclays Bank terms - which should be excluded, and consider as non ref group (Highlighted red)

Also, appreciate once the unique ref gets identified - the full row gets copied and pasted from 60th line & rest not having ref after 100 th line. of the same tab.

Attached a sample sheet with 2 currency!! Please let me know if any questions.

Thanks a lot in advance!

Regards
Ram

Originally Posted by NeedForExcel

To start with, let me know if the attached file is OK?

Hello NFxL,

Thanks for your response!

Your understanding is excellent and your work on sheet is very good.

However, is it possible to also include those items not having the 6 digit reference *123456* in - remove not needed section, along with those R.B.O.S entries. For Ex: 9 line items (highlighted in orange) in GBP & 2 in USD.

These are further investigated & work is yet to be done.

I have attached re-worked sheet for your refernce, which i tried for both currency.

Kindly let me know, if you have any question.

Regards
Ram