On
an Excel sheet called 'CUT LIST' I need a button, called 'UPDATE'. When
that button is click, it should do the following on the sheet called
'DATA' (in the same workbook):
Look for the rows with the word 'DUE' in column P.
*Those were lawns that were to be cut and are now complete. This is to
update the data sheet to show these are now complete, as of today (when
the Update button was clicked).
For every one of the rows with DUE shown in col. P, find the first blank cell in that row (going left to right).
*So, in the first row shown as DUE, row 7, the first blank column/cell
is J. The next row shown as DUE, row 13, the first blank column/cell is
N, etc.
And finally, in those first blank columns along those DUE rows (J7,
N13, H15, etc) enter/choose "Done - *Owe" from the validation dropdown
list, and in the very next cell to the right of that, enter todays date.
Does anyone know how I can accomplish this?
Thanks!
Jen