Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy formula to summary sheet (WinXP 2003)

    I have a set of sheets in my workbook which calculate quarterly totals for annual leave etc for a group of staff, one quarter per worksheet. I have added a worksheet to summarise each quarter of each year, and need a way to copy the quarterly totals to the summary sheet. I used countif() to add up all the different types of leave for each person, giving a row of cells with the totals. I hoped I could copy the formulas to the summary sheet and have them still refer to the absolute range, but the paste just copies the formulas with relative refs. to the summary sheet which i dont want. I hope this is clear, if not I can try to attach an example.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy formula to summary sheet (WinXP 2003)

    Try Edit | Paste Special > Paste Link. This won't copy the formulas, but it will create formulas that refer to the cells in the quarterly sheets.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy formula to summary sheet (WinXP 2003)

    This is perfect! Now the values displayed in the summary sheet are the same as the ones in each 4ly block, and i can use them in adding up etc.
    Many thanks for an ideal answer. Frank

Posting Permissions

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