Conditional message

[amwilber]

Hello,
I have a form that I already have set up to auto-calculate the amount of work certain workers will have, and when that work will end. Basically I just put the amount of hours remaining into the cells, and the program will calculate out the amount of hours dedicated to each job in coorelation with the amount of capacity (hours per week) these people can work. Now, I would like to create something where I could search through these people's hours, and when the number of hours in their fields does not match that of their capacity (lets say 30 hours), then it will display a message in a cell saying that the person is running out of work as of a certain week...the weeks are listed as columns on the top of the chart...basically I want it to say something like Pradeep is out of hours as of 5/18/2008 or something like that. I APPRECIATE THE HELP!!! The people on this site are awesome

***Below is what it looks like! THANKS AGAIN<SCRIPT language=JavaScript src="<A href="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT>

Resource Planning Sheet_External.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1		Resource	Portfolio	Capacity	Project	EstimatedHours	HoursRemaining	5/5	5/12	5/19	5/26	6/2	6/9	6/16	6/23	6/30	7/7	7/14	7/21	7/28	8/4	8/11	8/18
2
3		Amboji		75%	417	24	24	24	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
4		Amboji			418	104	80	6	30	30	14	0	0	0	0	0	0	0	0	0	0	0	0
5		Amboji			457	160	3	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0
6		Amboji			807	10	8	0	0	0	8	0	0	0	0	0	0	0	0	0	0	0	0
7		Amboji			837	160	160	0	0	0	5	30	30	30	30	30	5	0	0	0	0	0	0
8		Amboji			849	24	24	0	0	0	0	0	0	0	0	0	24	0	0	0	0	0	0
9		Amboji			852	32	8	0	0	0	0	0	0	0	0	0	1	7	0	0	0	0	0
10		Amboji			367	250	60	0	0	0	0	0	0	0	0	0	0	23	30	7	0	0	0
11		Bhatia			NoJobs
12		Bhatia
13		Bhatia
14		Kalisetty		50%	827	280	180	20	20	20	20	20	20	20	20	20	0	0	0	0	0	0	0
15		Kalisetty			806	32	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0
16		Kalisetty			763	60	60	0	0	0	0	0	0	0	0	0	19	20	20	1	0	0	0
17		Kanneganti		75%	675	24	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
18		Kanneganti			695	12	12	12	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
19		Kanneganti			696	16	16	16	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
20		Kanneganti			736	32	8	2	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0
21		Kanneganti			818	35	21	0	21	0	0	0	0	0	0	0	0	0	0	0	0	0	0
22		Kanneganti			860	8	2	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23		Kanneganti			481	39.5	39.5	0	1	30	8.5	0	0	0	0	0	0	0	0	0	0	0	0
24		Chenna		100%	FMCIReports
25		Lingampally		100%	RidersEdgeDealerChanges
26		Srivastava		100%	637	160	20	20	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
27		Srivastava			842	60	40	20	20	0	0	0	0	0	0	0	0	0	0	0	0	0	0
28								0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
29		Ramachandran		50%	825	24	13	13	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
30		Ramachandran			826	80	31	7	20	4	0	0	0	0	0	0	0	0	0	0	0	0	0
31		Ramachandran						0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
32		Reinkober		25%	617	24	16	10	6	0	0	0	0	0	0	0	0	0	0	0	0	0	0
33		Reinkober			601	48	48	0	4	10	10	10	10	4	0	0	0	0	0	0	0	0	0
34		Reinkober			331	36	32	0	0	0	0	0	0	6	10	10	6	0	0	0	0	0	0
35
Overall Outlook

 

[amwilber]

I think possibly using a button on this might work...i just don't know how to get the if statement to work...would I use a Do Until statement?

 

[amwilber]

I think possibly using a button on this might work...i just don't know how to get the if statement to work...would I use a Do Until statement?

Any good ideas from anybody? I am open to anything here!!!

 

[amwilber]

Any good ideas from anybody? I am open to anything here!!!

Does anyone have any ideas? I have been working on this for a day now and I can't figure it out! THANKS FOR THE HELP!!!