macro to copy specific cells from multiple sheets

**Costasg** · 07-06-2011, 08:01 PM

Hello all,

I need a macro to copy certain cells from many sheets into a new one. I am attaching a sample. what I want to do is copy cells "G5" "G6" "G18" from the sheets with the month names (not the main one) into a new one and put them in three different columns (all G5s, G6s, G18s).

Many thanks in advance

**Leith Ross** · 07-07-2011, 01:53 AM

Hello Costasg,

This macro will create a worksheet called "Summary" and add the ranges G5:G6 and G18 from each monthly sheet into columns "A:C. This macro has been added to the attached workbook.

Please Login or Register  to view this content.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

**Thrux** · 07-07-2011, 02:23 AM

Hello,

There is most likely a better way to achieve your request. Although, I am new to this and figured I could help. Also look at the OrSheet, it will display the value on the page even when changed. Hope I could help.

Regards,

**Thrux** · 07-07-2011, 02:25 AM

Wow Leith, that is very efficient. I posted without refreshing so I did not see your reply. Puts my mess of code to shame. Good Work!

**Leith Ross** · 07-07-2011, 03:23 AM

Hello Thrux,

You code isn't really all that bad. You have the concept of what needs to be done and that's about 50 percent of the battle. The macro recorder is a stepping stone. The code it produces works but isn't refined.

As you do more coding, and visit the boards for ideas, your code will become better and better. None of us were born knowing all this. It takes time to learn it and then a little more time to refine it.

**Costasg** · 07-07-2011, 05:33 AM

Many thanks for your valuable help guys! You just saved me a lot of time.

**mcollins999** · 05-24-2012, 09:09 AM

OK, this is awesome, Leith. I'm struggling with getting this to write to a new workbook instead of a new worksheet. When I add a piece of code to create a new workbook, that new workbook becomes the main workbook and I cann't get the summary to refer to the "old" workbook. Any suggestions?

**arlu1201** · 05-24-2012, 09:34 AM

Mcollins999,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.