Limit Monitor

ayazgreat

Well-known Member
Joined
Jan 19, 2008
Messages
1,151
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
ABCDE
1DATED.IDP-IP-2Status
21-Dec-07100122
31-Dec-07100222
41-Dec-07100322
51-Dec-07100422c
61-Dec-07100522
71-Dec-07100222c
81-Dec-07100322
93-Dec-07100422c
DB



Excel Workbook
ABCDEF
1Credit LimitAvailable Limit
2D.IDLimit P-ILimit P-2Availble Limit P-1Availble Limit P-2
3100110583
4100210581
5100310561
6100410561
7100510583
8100210561
9100310561
10100410561
Limit


Thanks in advance
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

ayazgreat

Well-known Member
Joined
Jan 19, 2008
Messages
1,151
Excel Workbook
ABCDEF
1Credit LimitAvailable Limit
2D.IDLimit P-ILimit P-2Availble Limit P-1Availble Limit P-2
3100110583
4100210583
5100310583
6100410583
7100510583
8100210583
9100310583
10100410583
Limit
 
Upvote 0

Forum statistics

Threads
1,191,134
Messages
5,984,864
Members
439,921
Latest member
Neocold

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top