Macro to Copy cells data and paste on next empty row

**tfaridi** · 12-14-2012, 04:30 PM

Hello,

I need help with a task im trying to accomplish in my excel workbook using macros.

I want the macro to copy data in cells Q3 to T3 (4 cells), and paste on first empty cell in column W in the sheet. For example, if the first empty cell is W2, then it should paste the cell data on cells W2 to Z2 (4 cells)

Thank you in advance for the help!!!

Tariq

**alansidman** · 12-14-2012, 05:35 PM

try this:

Sub CopyPaste()

    Range("Q3:T3").Select
    Selection.Copy
    Range("W1").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Select
    ActiveSheet.Paste
End Sub

Macro to Copy cells data and paste on next empty row

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro to Copy cells data and paste on next empty row

Re: Macro to Copy cells data and paste on next empty row

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions