Microsoft Office Forums - View Single Post - [Solved] How to duplicate a block of cells that contain formulas without losing reference?

Thread: [Solved] How to duplicate a block of cells that contain formulas without losing reference?

View Single Post

Old

10-29-2022, 09:19 AM

ColtonYYZ

ColtonYYZ is offline

ColtonYYZ uses Windows 11

Windows 11 ColtonYYZ uses Office 2021

ColtonYYZ uses Office 2021

Office 2021

Novice

The original poster

Join Date: Oct 2022

Posts: 4

ColtonYYZ is on a distinguished road

Default

Thanks to another member on one of the other forums I posted on, I now have the answer I've been looking for:

=INDEX(Sunday!$C:$J,QUOTIENT(ROW(D45)-14,31)+3,COLUMN(D45)-3)

Reply With Quote