Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I need a formula in sheet named summary that will reference to cell U152 in sheet1

    Each month a new column will be inserted on sheet1 where Column AE is and the data from U152 will be copied into Sheet1. New data will be imported into column U

    I need a formula in cell C3 in the summary sheet that will change each time a new column is inserted in column AE i.e the sdata on sheet1 will keep on shifting to the right

    Your assistance will be most appreciated

    Regards

    Howard

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,183
    Thanks
    47
    Thanked 983 Times in 913 Posts
    You could anchor the reference (press F4). You end up with $U$152.

    cheers, Paul

Posting Permissions

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