Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FILTER & IMPORT DATA | Excel Discussion (Misc queries) | |||
Excel Row Limitation - Import External Data | Excel Worksheet Functions | |||
how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) |