Excel Macro Copy cells and pastes them in another sheet

myfe · July 1st, 2012, 08:21 AM

Hi All,

I am trying to create a macro that copies cells and past C16, C18, C20, E16, E18, G16, G18 in another sheet (sheet1) in the next blank row and save the sheet( copy value only).

Thanx for the help

kompiuteriumeistras · July 2nd, 2012, 02:56 AM

Code:

Sheets("TEST_IN").Cells(1, 1).Value = Sheets("TEST_FROM").Cells(1, ).Value

myfe · July 2nd, 2012, 06:41 AM

thanx
by the way I cross posted my Qusstion I didn't know that I shoudn't
Thanx Qusstion solved