Moving data from one sheet to another

[Brew]

How do I create a code that will copy and paste the cell contents in g6:I551 within sheet "BEE" to columns C,D,E starting with row 5 in "sheet5"

 

[erik.van.geit]

Hi, Brew,

How do I create a code ... copy ...

you can do this by recording a macro with the macro recorder
you can take a look in the helpfiles for COPY
you can do a search in (your) posts here on the Board: you will find "search" on top of the page or you can google http://www.google.com/advanced_search?q=site:MrExcel.com

kind regards,
Erik

 

[Yogi Anand]

How do I create a code that will copy and paste the cell contents in g6:I551 within sheet "BEE" to columns C,D,E starting with row 5 in "sheet5"

Hi dk:

How about ...

Sheets("BEE").Range("G6:I551").copy Sheets("Sheet5").Range("C5")

 

[Brew]

Thanks for the help gentleman. Yogi, that works perfectly.