How to duplicate a block of cells that contain formulas without losing reference?

		Microsoft Office Forums > Microsoft Excel > Excel
How to duplicate a block of cells that contain formulas without losing reference?

FAQ

Thread Tools

Display Modes

10-29-2022, 09:19 AM

ColtonYYZ

Windows 11 How to duplicate a block of cells that contain formulas without losing reference?

Office 2021

Novice

Join Date: Oct 2022

Posts: 4

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)

Tags

bulk copy paste, formulas, reference

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to create a block text and when click on the title of block hide and unhide the block	labasritas@free.fr	Word	4	09-17-2017 01:17 PM
Does Excel have a way of using variables to easily update reference formulas?	Lluewhyn	Excel	1	10-19-2016 07:59 AM
large workbook needs restarted every month with deletions and resort without losing formulas	llhail	Excel Programming	1	06-02-2015 05:34 PM
Formulas/Scripts That Cross Reference & Import Data	ekeithjohnson	Excel Programming	3	08-23-2014 11:26 PM
Losing rows when pasting split cells	Gitley	Word Tables	1	01-15-2013 07:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 PM.