#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default macros

how do I in an Excel 2003 macro...Take 5 workbooks...goto a specific
worksheet in that work book. autofilter on a cell copy and paste that
data in a blank workbook...

Kat

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 207
Default macros

Kathryn_d,
If you are sure of the necessary steps, record your own macro.
Open the workbook, select "Tools", select "Macro",select "Record New macro".
Make sure you select "This workbook" and name it something easy to remember.
Then just walk throught the steps and Excel will record everthing you do.
When done try running the macro.
Good luck,hth

" wrote:

how do I in an Excel 2003 macro...Take 5 workbooks...goto a specific
worksheet in that work book. autofilter on a cell copy and paste that
data in a blank workbook...

Kat


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
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros Brian Day Excel Programming 1 March 29th 07 11:20 PM
choose default macros Not Enabled / Macros Enable Setting BEEJAY Excel Programming 2 June 30th 06 01:07 PM
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM
Macros inside macros, and pasting into macro code. pagelocator[_2_] Excel Programming 1 November 24th 04 09:11 AM
Macros not appearing in the Tools Macro Macros list hglamy[_2_] Excel Programming 5 October 24th 03 09:10 AM


All times are GMT +1. The time now is 11:35 AM.

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

About Us

"It's about Microsoft Excel"