I have uploaded the file to the group. It is called SPC_Cells.xlsx. I
hope this helps. Nothing too fancy at this point, but again, I would
like to try and automate the copying of the formula into new rows so
that the uses don't have to do it.
Cheers,
Russ
On Jul 25, 11:29 am, Dilip Pandey wrot
You can create a list for Parent Items.
Afterwards whenever you need to add data, you need to go to the last row of
you data (where excel is showing * and Highlighted row after that).
All the formulas applied to entire column till that row will be
automatically copied to next row.
Regards,
Upe
Hi Russ,
If it is possible and do not have any data sharing issue, then please
share the spreadsheet with the group. Alternatively, you can provide
the dummy scenario(s) as well.
We all are here to learn and explore the vast features and
capabilities of Excel, and these type of practical problem
Good idea. Your suggestion gave me this idea:
Lock the entire column that contains the child count and when a value
is entered into the key column on a new row (the license number), use
a macro to insert the formula into the locked column.
I guess I was hoping there was a way to assign a formula
I think a fairly 'simple' way to do it is using a worksheet_change event.
When the sheet is changed, have the event check to see if the column
changed is a specific column that always has data.
then, the macro could unprotect the sheet, insert the formula, then
re-protect the sheet.
sound feasible
