Forum Discussion
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 ...
See the attached version.
The formula in D15 on Timesheet is =Monday!B3. Shouldn't that be =Monday!C3 ?
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!
See the attached version.
- OMG you're the best!!!!! I've never used INDEX or QUOTIENT before but this is perfect!! I texted it by adding another person for each day and it pulled the correct data as I used unique but random times to verify! Works like a charm! My hats off to you!!
Hi, sorry, if I may, could I ask for you to explain what these numbers do in the formula please?
-14,31)+3,COLUMN(C13)-3)
Once I understand them, I can tweak them for a different excel file I am working on. Thank you!