Macro to copy data from one sheet, paste in another sheet

Hi guys!

New to the thread and this forum is great as I'm really interested in learning how to create macros.
I would like to ask for help. I need to copy a certain group of cells from one sheet to another, and then do it for x number of times. I'm just using the record function and now i'm lost. Here is the code i currently have:

Sheets("Mapping QTR2").Select
Range("B137:D230").Select
Selection.Copy
Sheets("ExpDB_Q1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.End(xlDown).Select
Range("A99").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

also, column C is blank. i would like to get the values from another list in the same workbook, say "branch list". I would like to populate Column C with one specific branch for each "batch", if that makes any sense...

hope you guys can help...

thanks a lot

papi-O,

Welcome to the forum! It would be helpful if you used code tags for posting vba code see rule 3 of the forum rules http://www.excelforum.com/forum-rule...rum-rules.html

Recording Macros is a great way to get a start on what you want to do, but you almost never need to use the .Select method.

You can create variables and assign or initialize these variables to things like specific workbooks, worksheets, ranges etc... For example

Please Login or Register  to view this content.

Now you have declared and initialized the variable to refer to exactly your current workbook and the two specific sheets in your workbook. Further....

Please Login or Register  to view this content.

Hope that helps get you started. Obviously it can get much more in depth with dynamic ranges (ranges that automatically find the last filled cell etc...), but this should get you started. Google is your friend as is trial and error for learning.

Happy coding!