Forum Discussion
Matching formula from reference cell?
I have a very large spreadsheet in which I occasionally want to change a specific formula across the board. Unfortunately, the cells are not contiguous so I can't easily drag and autofill. Is there...
RandomKSM wrote:Unfortunately, the cells are not contiguous so I can't easily drag and autofill.
That suggest a bad model.
You should change your setup.
Yeah, it grew over time. Each column has a different way of dealing with potential data but is broken up each day and week for subtotals. If I drag and autofill, I paste over the subtotals.