Hi Everyone,

This little problem has been driving me nuts over the past 24 hours, I think I'm missing something obvious?

I've attached the test sheet I'm working on if it helps - I have an employee who needs to enter data in a certain order on sheet 1, column B. Column A and C are just codes for her to double check against.

I then need that data set to be copied and auto-sorted onto Sheet 2 by Column B - I'll then add some fluff and fancy charts later. I'll have about 40 rows of data for her to fill in, if I can get this to work I'll roll it out on a few other spreadsheets I have - which would be seriously helpful!

Macro Test.xlsm

Any and all help is greatly appreciated and will be rewarded with cyber beer...

Thanks

Mark