exact match and offset more than once?

Hi all

I have one condition which needs to be matched. This code I wrote can find the first instance and then offset data to another worksheet accordingly.

My question is whether than can be done for every other instance that appears on my sourcesheet 'Invoicing'. I have considered putting a loop in, but this will only find the first instance over and over again which is pointless.

Any input would be great!

(BTW, i realise these are crazy offset values, but the invoice I am working with is organised in a grid - not my choosing!)

Cheers

Danny.

Please Login or Register  to view this content.

Thanks for your reply. I've enclosed a sample workbook here.

For every occurance of 'AG' it should offset the data from 'invoicing' on a new rows on 'AG's sheet (or even every 2 rows). The same should occur for any other person.

D.

Thanks for the tip on find procedures. I adapted some code and ended up with a half find/half match. Works great now.

Please Login or Register  to view this content.

Just note to any forum searchers. This needed exact matching to work how I wanted. See the following amendedment to the code.

Cheers

D.

Please Login or Register  to view this content.