Excel 2007 Macro [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

Could you help me in writing a macro for exporting data from certain cells in sheet 1 to sheet 2.

I use Windows 7 and excel 2007

Thanks!!

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
the question is vague

suppose you want to transfer cell B1 in sheet1 to the first available row and in column A in sheet 2


the macro will be something like this

With Worksheets("sheet1")
.Range("B1").Copy
With Worksheets("sheet2")
.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
End With
End With

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!