Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi gang,
    In Sheet1 Column A I have a list of names. I want the same list of names in Sheet2 Column A even if a row is added to Sheet1.
    What formula should I use?
    Thanks.
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could use this formula in A1 on Sheet2:

    =IF(INDIRECT("Sheet1!A"&ROW())=0,"",INDIRECT("Shee t1!A"&ROW()))

    Fill down as far as you think data on Sheet1 will potentially reach.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Works just fine.
    tks
    Johanne Champagne
    Montreal (Quebec) CANADA

Posting Permissions

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