Gavin,
You'll need to give a little more info like Which column contains the data
you would like to sort by. Whick row your data starts on ect...

"Gavin" wrote:

Ok so I am a novice attempting to run before I can crawl!
My Problem is the following:

I have set up a work book that contains 4 sheets named, PRODUCTION, ORDER,
INVOICE, DELIVERY NOTES.

PRODUCTION is the "Master Sheet" and using VLOOKUP I have sucessfuly managed
to place all relevent information on the other 3 Sheets.

I now need to set up Macros for each sheet to print the information using 3
seperate "Button (form control)" which are placed on the PRODUCTION sheet.
However I need the information "Sorted" automatically before it prints.

I have started the the Macro for INVOICE but have now got completley
confudes. I hope that someone out there can make sense of what I am
attempting to do and help me.

Many Thanks in advance!