Results 1 to 2 of 2

Thread: Fill-out column with another columns-info

  1. #1
    holo man
    Guest holo man's Avatar

    Fill-out column with another columns-info

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I come to this macro, because its alike to what I want.

    Sub Enncolumnar()

    Dim C As Range
    For Each C In Selection
    If IsEmpty(C.Offset(1)) Then
    C.Copy Range("p" & Cells.Rows.Count).End(xlUp).Offset(1)
    Range(C, C.End(xlDown)).Copy Range("p" & Cells.Rows.Count).End(xlUp).Offset(1)
    End If
    Next C

    End Sub

    Is there a method to alter this in order that the selection is completed in a column in place of a row, in addition columns on others worksheets?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Do you mean transpose the data, or just copy the next block horizontally?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts