Exel query - 2007

bloodline76

bloodline76

bloodline76

Soldato
Joined
7 Feb 2004
Posts
9,511
I was wondering if there is anyway of doing the "Sort by" command for all tabs at once?

I have to run nightly reports and at the moment I go through them individually to sort them.

Thanks
 
Create a macro? Especially for something you're doing each night a macro seems perfect sense to me.
 
If you're having trouble finding the macro button click on the office icon in the top left, then click on options and then tick the developer ribbon tickbox.
 
Our client likes the reports that I run in a particular fashion, so I have to have multiple tabs.

I am not sure about marcos to be honest, never used them, but it does sound like it could save me some time.

Just so you understand. I get a report that comes through into excel and then I have to sort this information by date and time. Then by other specific columns in an order.

Is that something I could setup for a macro?
 
Yes. Simply hit the macro record button then do whatever it is you normally do then hit the stop button. You will then have created a macro. Make sure to make the macro available to any documents and then each time you load up a new one just select that macro and run it. Done.
 
fini said:
Yes. Simply hit the macro record button then do whatever it is you normally do then hit the stop button. You will then have created a macro. Make sure to make the macro available to any documents and then each time you load up a new one just select that macro and run it. Done.
Click to expand...

Thanks. I will give that a try.

Thanks everyone!
 
Macro is the way forward here, defintely. Well, either that or VBA, but that's just excessive for a simple sort.
 
You must log in or register to reply here.
Back
Top Bottom