VBA to find the last order and then reference it against another cell value?

[danbates]

Hi,

I have 13 palletisers at work which all have a letter of identification.

They are B, C, D, E, F, G, H, J, K, L, M, N, P.

What I would like is to be able to find the last changeover of each of the palletisers on my changeover sheet and then find what the market it is on.

Column E has the palletiser ID and column P has the market. They are always on the same row.

Then I would like to be able to count the amount of palletisers that are on the market CN and have that count in range A1.

Hope this makes sense but if not then please ask.

Thanks

Dan