Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
fab fab is offline
external usenet poster
 
Posts: 6
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default 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,



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FILTER & IMPORT DATA RICARDO COX Excel Discussion (Misc queries) 0 September 22nd 06 06:45 PM
Excel Row Limitation - Import External Data Avadivelan TCS Excel Worksheet Functions 5 September 13th 06 04:53 PM
how do i import data from excel, sort it then that information is. jaxx Excel Discussion (Misc queries) 2 March 7th 05 09:49 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"