Update first blank column in row

[Jenawade]

Lawn3.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	CHARGED
2	OUTSTANDING
3						DATESCUT
4	NAME	PH#	ADDRESS	DAYS	CUT	1		2		3		4		5		CUTDUE
5	BSMITH	555-1212	1234Street	7	6/22	Done-Paid	6/1/08	Done-Paid	6/7/08	Done-*Owe	6/15/08
6	JDOE	555-1212	5678Road	7	6/21	Done-Paid	5/29/08	Done-Paid	6/7/08	Done-Paid	6/14/08
7	HTAYLOR	555-1212	8768Lane	14	6/28	Done-Paid	6/1/08	Done-*Owe	6/14/08							DUE
8	OHARRISON	555-1212	2255Alley	7	6/21	Done-*Owe	6/14/08
9	WSAMSON	555-1212	8577Hill	7	6/21	Done-Paid	6/7/08	Done-Paid	6/14/08
10	NWILSON	555-1212	6555Skyline	14	6/21	Done-Paid	6/7/08
11	SATCHINSON	555-1212	1244Street	7	6/14	Done-Paid	6/8/08	Pre-Paid10	6/14/08	Pre-Paid10	6/22/08	Pre-Paid10	6/29/08	Pre-Paid10	7/6/08
12	PWILSHIRE	555-1212	5898Road	14	6/22	Done-Paid	6/8/08
13	GTRAMLIN	555-1212	8799Lane	14	6/28	Done-Paid	6/9/08	Pre-Paid10	6/28/08	Pre-Paid10	7/12/08	Pre-Paid10	7/26/08			DUE
14	FRANGELY	555-1212	3155Alley	7	6/18	Done-Paid	6/11/08
15	MTREELINE	555-1212	8767Hill	7	6/26	New-CutDue	6/26/08									DUE
16	IPRALINES	555-1212	6895Skyline	7	6/26	New-CutDue	6/26/08									DUE
17	KPADDLY	555-1212	8877Lane	7	6/21	Done-*Owe	6/14/08
18	NYARDLY	555-1212	3388Alley	14	6/28	Done-Paid	6/14/08									DUE
19	QFORD	555-1212	9191Hill	7	6/21	Done-*Owe	6/14/08
20
21
22
DATA

Every customer with a cut 'DUE' (as shown in column P) is on the 'CUT LIST' sheet for sorting and printing. I've been asked for an 'UPDATE' button on the 'CUT LIST' sheet, that, once those 'DUE' cuts are completed, will find the first blank column on the above 'DATA' sheet, from col. F going to the right, for each customer with 'DUE' listed in column P (there were many more columns, deleted temporarily for the above image), change the validation list dropdown to "Done - *Owe" and enter the current date in the next blank cell to the right.

My "expertise" with visual basic is currently copy/paste, or as I often call it in my particular case, airhead level.

Can anyone help me with some code for this? =o) Pretty please?

 

[Jenawade]

Lawn_.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	CHARGED
2	OUTSTANDING
3						DATESCUT
4	NAME	PH#	ADDRESS	DAYS	CUT	1		2		3		4		5		CUTDUE
5	BSMITH	555-1212	1234Street	7	6/22	Done-Paid	6/1/08	Done-Paid	6/7/08	Done-*Owe	6/15/08						L5
6	JDOE	555-1212	5678Road	7	6/21	Done-Paid	5/29/08	Done-Paid	6/7/08	Done-Paid	6/14/08						L6
7	HTAYLOR	555-1212	8768Lane	14	6/28	Done-Paid	6/1/08	Done-*Owe	6/14/08							DUE	J7
8	OHARRISON	555-1212	2255Alley	7	6/21	Done-*Owe	6/14/08										H8
9	WSAMSON	555-1212	8577Hill	7	6/21	Done-Paid	6/7/08	Done-Paid	6/14/08								J9
10	NWILSON	555-1212	6555Skyline	14	6/21	Done-Paid	6/7/08										H10
11	SATCHINSON	555-1212	1244Street	7	6/14	Done-Paid	6/8/08	Pre-Paid10	6/14/08	Pre-Paid10	6/22/08	Pre-Paid10	6/29/08	Pre-Paid10	7/6/08		P11
12	PWILSHIRE	555-1212	5898Road	14	6/22	Done-Paid	6/8/08										H12
13	GTRAMLIN	555-1212	8799Lane	14	6/28	Done-Paid	6/9/08	Pre-Paid10	6/28/08	Pre-Paid10	7/12/08	Pre-Paid10	7/26/08			DUE	N13
14	FRANGELY	555-1212	3155Alley	7	6/18	Done-Paid	6/11/08										H14
15	MTREELINE	555-1212	8767Hill	7	6/27	New-CutDue	6/27/08									DUE	H15
16	IPRALINES	555-1212	6895Skyline	7	6/27	New-CutDue	6/27/08									DUE	H16
17	KPADDLY	555-1212	8877Lane	7	6/21	Done-*Owe	6/14/08										H17
18	NYARDLY	555-1212	3388Alley	14	6/28	Done-Paid	6/14/08									DUE	H18
19	QFORD	555-1212	9191Hill	7	6/21	Done-*Owe	6/14/08										H19
20
21
DATA

I did use multiple If statements and concatenate them together to get a cell that contains the cell address of the first blank cell in each row -- but now I don't know what to do with it from here to get what I want. I spent the entire evening and half the night searching through here and the internet at large and I'm stuck...

 

[schielrn]

Not sure I am following you? Which sheet do you want the formula in and what exactly are you wanting to see? Could you maybe provide a sheet with expected results?

 

[Jenawade]

On a sheet called 'CUT LIST' I need a button, called 'UPDATE'. When that button is click, it should do the following on the above sheet called 'DATA':

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 all 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 above, in row 7 the first blank cell is J. The next row shown as DUE, row 13, the first blank cell is N, etc.

In those cellsl (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 that make sense? I have talent for confusing people when I think I'm making sense!