I work for a tournament scheduling company and I am retrofitting our brackets in excel. I have written all the formulas but there are 50+ brackets to apply them to. Since the brackets change in size and shape so much I am having trouble finding a quick way to copy and paste formulas to different sized brackets without having to change a bunch of things for each one.
I previously just manually dragged all the cells within the formulas but this takes far too long.
I am trying out using the offset and indirect functions but I still end up having to use multiples of this so I still have to move a bunch of cells within the formula.
Is there a way to make it reference the Indirect cell one time and use it multiple times so I would only have to move one reference?
Bookmarks