Forum Discussion

bryen79's avatar
bryen79
Copper Contributor
Oct 29, 2022
Solved

How to duplicate a block of cells without losing formula references

Please note: I have posted this question on another website a few days ago and have not received any answers to it. I am hoping on of you kind folks here might know the answer. I am creating time ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Oct 29, 2022

bryen79 

Your workbook doesn't contains sheets named Sunday etc. so I have no idea what to do.

bryen79's avatar
bryen79
Copper Contributor
Oct 29, 2022

Sorry, I only supplied a sample. I have uploaded a better workbook with the daily sheets included.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 29, 2022

    bryen79 

    The formula in D15 on Timesheet is =Monday!B3. Shouldn't that be =Monday!C3 ?

    • bryen79's avatar
      bryen79
      Copper Contributor
      Oct 29, 2022

      HansVogelaar 

       

      Hi thanks for catching this... I've been staring at my screen for so long I am getting sloppy now.

      So...

      For Mary, D45 should be =Sunday!C4
      For Susie, D76 should be =Sunday!C5
      For Peter, D107 should be =Sunday!C6

       

      I've updated the sample book and made those lead in examples for you.

       

      Thank you by the way, for helping me on this!

Resources