Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Formula for copying a column of cells into another sheet

  1. #1
    New Member
    Join Date
    Oct 2009
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula for copying a column of cells into another sheet

    Hi there,

    I'm very new to Excel, and I'm having trouble figuring a few things out. Hopefully this will be very easy for you guys!

    In Sheet 1, I have a column of cells that I would like to also appear in Sheet 2. If I add a new row to the column in Sheet 1, I would also like it to be updated automatically in Sheet 2. Currently, I can get it to show the contents of individual cells from Sheet 1 in Sheet 2 by using this formula in the formula bar for each cell in Sheet 2:

    =Sheet1!A3 (or whichever cell it is)

    That's fine, but I'd like to just have a formula that will reproduce the entire column (ie. without a fixed range, as new rows are going to be added to the column).

    If anyone could point me in the right direction, I'd be very very grateful. Thanks.

  2. #2
    Board Regular Purple Youko's Avatar
    Join Date
    Sep 2004
    Posts
    265
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for copying a column of cells into another sheet

    2 possible ways

    1) repeat teh formula that you have in all the relevent cells in sheet 2
    2) put this function in your sheet1 code window
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
      Dim colnum As Integer
      Dim rownum As Integer
     
      colnum = Target.Column
      rownum = Target.Row
      
      Sheets("sheet2").Cells(rownum, colnum).Value = Cells(rownum, colnum).Value
    End Sub

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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