Macro's and Excel worksheets

Messages
7,969
Name
Sara
Edit My Images
Yes
I have a file in Excel that has 50 seperate worksheets. The worksheets are all in the same format. I want to know if there is a macro that can basically sort data in each of these worksheets in what ever order I specify in one go?

So for example, I go to worksheet 10 and want to sort column A into ascending order - Can all the worksheets then be sorted in the same order at the same time as worksheet 10?
 
Back
Top