Hello Wizards,
Does anyone know how I can copy and paste formulas from specific columns to other rows by row count. For example:
Let say I have 16 rows of formulas.
G2 has a formula, as does H2, G3, H3,G4, H4,G5, H5 Etc.
Now, let’s say the next set of data only has 12 rows of formulas, how do I copy the formulas to those 12 rows only?
And the next set of data may have 15 rows of data.
I know I can sort and cluster by row count (all the 16s together, all the 15s together, all the 12s together).
Forever grateful
Frank
Does anyone know how I can copy and paste formulas from specific columns to other rows by row count. For example:
Let say I have 16 rows of formulas.
G2 has a formula, as does H2, G3, H3,G4, H4,G5, H5 Etc.
Now, let’s say the next set of data only has 12 rows of formulas, how do I copy the formulas to those 12 rows only?
And the next set of data may have 15 rows of data.
I know I can sort and cluster by row count (all the 16s together, all the 15s together, all the 12s together).
Forever grateful
Frank