fab, if it is the same thing you are doing each time record a macro when you
do it, tools record macro, then just run it the next time.
And if you are new to macros you may also what to have a look here on
getting started with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"fab" wrote in message
...
I usually receive an excel report with about 20 columns. Then I have to
delete about 10 of them and rearrange the remaining 10 columns in a
different
order. Is there a template or anything I can do to do this for me
automatically? I do this many times during the day and waist a lot of
time.
Thank you,