How do I import and filter worksheets into a template?
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, |
How do I import and filter worksheets into a template?
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, |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com