need help macros excel 2003

  • Thread starter Thread starter kathepoo
  • Start date Start date
K

kathepoo

I have 5 workbooks that i need to go to a sepcific worksheet do an
autofilter on a specific cell then coping and pasting that range into
a new work book.

If you could help I would appreciate it.

kat
 
Turn on Learn Macro (Tools - Macro - Record New macro) and perform the steps
you normal do. Stop macro (Tools - Macro - Stop Recording). Then post code
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top