Popup/Notification Box comparing cell data across multiple worksheets

Hello All,

I'm having difficulty with a cell comparison popup/alert. I have 100+ worksheets in 1 workbook.

Column A contains text I need to show, Column C contains a fixed numerical cell, Column D contains a variable numerical cell (Data is pulled externally). This data starts at Row 22. If inventory in Column D is less than Column C, I want the alert to show when opening the workbook.

The popup/alert i'm attempting to create should show a message when opening the workbook, scanning through the 100+ worksheets and showing the alert:
"Apples inventory are 15 out of 30"
"Bananas inventory are 5 out of 50"

Apples = Column A, Worksheet 1
Bananas = Column A, Worksheet 2
15 = Column D, Worksheet 1
30 = Column C, Worksheet 1
5=Column D, Worksheet 2
50=Column C, Worksheet 2


Any help with a simple VBA or anything? The code I'm running only works on a localized worksheet and not through the workbook, nor does it show Column A in the alert box.

Thanks!

Can you post a sample file?

Attached is the example file - without the code.

Code I used was similar to this:

Please Login or Register  to view this content.

Anyone have a better idea or way of doing this?

Thanks!

Hi,

Try this macro. You will see the results in 'Result' tab.

Abduljaleel.mca,

Thanks for that! Looks great except i'm looking more for an alert box that shows me the inventory vs adding another sheet.

This gives me a good base to work with however, I may be able to code in a msgbox for this or something.

Thank you!

I have updated the code, it will show the output in alert box.