D
Daniel Rascoe
Cell B1 has a formula which generates the row # of the last nonblank cell in
Column E. The current value of cell B1 in my spreadsheet is 10,012.
Cell G13 has a formula in it.
Cell H264 has a formula in it.
Cell AC767 has a formula in it.
What I want is for Excel to automatically fill down the formulas from G13,
H264 and AC767 to the row number in cell B1 automatically.
The result would be that G13 would be filled down to G10012, H264 would be
filled down to H10012 and AC767 would be filled down to AC10012.
I want Excel to do this automatically instead of me choosing the cells and
manually filling down.
Does anyone know how to accomplish this?
Daniel
Column E. The current value of cell B1 in my spreadsheet is 10,012.
Cell G13 has a formula in it.
Cell H264 has a formula in it.
Cell AC767 has a formula in it.
What I want is for Excel to automatically fill down the formulas from G13,
H264 and AC767 to the row number in cell B1 automatically.
The result would be that G13 would be filled down to G10012, H264 would be
filled down to H10012 and AC767 would be filled down to AC10012.
I want Excel to do this automatically instead of me choosing the cells and
manually filling down.
Does anyone know how to accomplish this?
Daniel