Macro for copy sheet

  • Thread starter Thread starter Lynn Bartling
  • Start date Start date
L

Lynn Bartling

I am a novice when it comes to macros...but I have to copy a bunch of
spreadsheets...both copying to the same workbook and copying to a new
workbook...I'd like to streamline the process and rather than copy/move,
etc., I wanted to either make a macro button or a shortcut key. I can't
find anything on the web to help me. I have to do this every week on
different sheets...so I'd like to have a macro that works for all the named
sheets. Can this be done?
Thanks!
Lynn
 
Lynn said:
I am a novice when it comes to macros...but I have to copy a bunch of
spreadsheets...both copying to the same workbook and copying to a new
workbook...I'd like to streamline the process and rather than copy/move,
etc., I wanted to either make a macro button or a shortcut key. I can't
find anything on the web to help me. I have to do this every week on
different sheets...so I'd like to have a macro that works for all the named
sheets. Can this be done?
Thanks!
Lynn
Click to expand...
 

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

Similar Threads

Excel Move or Copy Stopped Working? 0
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Arrays containing variable sheets 2
Macro to copy value in field and insert it into filter 2
Excel VBA - macro that copies the sheets to another workbook 3
Get Name of Sheet to use in Macro 11
Macro that "shows all data " in several sheets. 1
Moving a bunch of data 1

Back
Top