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
Thanks in advance
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