Limit Monitor

[ayazgreat]

Hi All

I have 2 sheets having name DB and Limit. In DB sheet i enter data and in Limit sheet I check each ID avalable Limit I want to ask if it is possible that a macro checks available limit in Limit sheet when I enter values in DB Sheet in Columns C & D and gives me warning message if entered values in DB sheet exceed from available limit in Limit sheet

Excel Workbook
	A	B	C	D	E
1	DATE	D.ID	P-I	P-2	Status
2	1-Dec-07	1001	2	2
3	1-Dec-07	1002	2	2
4	1-Dec-07	1003	2	2
5	1-Dec-07	1004	2	2	c
6	1-Dec-07	1005	2	2
7	1-Dec-07	1002	2	2	c
8	1-Dec-07	1003	2	2
9	3-Dec-07	1004	2	2	c
DB

Excel Workbook
	A	B	C	D	E	F
1	Credit Limit				Available Limit
2	D.ID	Limit P-I	Limit P-2		Availble Limit P-1	Availble Limit P-2
3	1001	10	5		8	3
4	1002	10	5		8	1
5	1003	10	5		6	1
6	1004	10	5		6	1
7	1005	10	5		8	3
8	1002	10	5		6	1
9	1003	10	5		6	1
10	1004	10	5		6	1
Limit

Thanks in advance

 

[ayazgreat]

Excel Workbook
	A	B	C	D	E	F
1	Credit Limit				Available Limit
2	D.ID	Limit P-I	Limit P-2		Availble Limit P-1	Availble Limit P-2
3	1001	10	5		8	3
4	1002	10	5		8	3
5	1003	10	5		8	3
6	1004	10	5		8	3
7	1005	10	5		8	3
8	1002	10	5		8	3
9	1003	10	5		8	3
10	1004	10	5		8	3
Limit

 

[ayazgreat]

Could Any Ony Please Help

 

[ayazgreat]

Is this possible?

 

[ayazgreat]

Sir

Could any body please help?

 

[ayazgreat]

Waiting for your kind help

 

[ayazgreat]

Ok thanks no boday is not ready to answer it.