Bulk data sort

Hi,

I assume you mean you don't want to sort the sheets manually. One way or another you will need to address each sheet in turn, hence you will need a macro to do it.

The obvious solution is to use the macro recorder to capture a macro. Experiment a few times first so that you know excactly which areas to select and then switch on the recorder.

Afterwards you can then tidy up and simplify the macro by building an a loop to access each sheet. But that's for later. Get to first base first then post your macro and we'll adapt it.

Regards

Hi
Thanks for your reply and advice.
Please find attached file "Macro Solution"
I had to create 2 macro's as I forgot to mention the summary sheet I use is different to the other 12.
I still have to operate macro 1 12 times but it's far more efficient than the old sort method.
Please feel free to pull my efforts to pieces I'd appreciate another opinion.
Thanks -=- dustyv

you could simply repeat each sheet selecting it first probably far more efficient way but

Please Login or Register  to view this content.

Hi,

Can you upload your actual workbook rather than the text from the recorder. That will assist in being able to advise further.

As you can probably see there's a lot of redundant stuff in there.

Rgds

Hi Maretindwilson,
Thanks that works for me - perfect.
Being I have 12 sheets I have modified your offering to suit.
Thanks to all who contributed - very much appreciated.
Thanks again -=- dustyv

Hi,

When you have a moment would you visit your original post and mark it as SOLVED.

Many thanks