Help with linking data validation list and functions on multiple sheets.

Do you have an example workbook?

To Attach a Workbook:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit

here's one:

There are two macros in the workbook:

Please Login or Register  to view this content.

The above changes the dropdown selection to NO when ever the worksheet is activated. It checks the hardware list sheet to see if the count is zero. If it is, then it moves the cursor to the adjacent cell so that the dropdown cannot be selected and gives a zero count message.

The code below is triggered whenever there is a change in check list sheet. If the change was triggered by a change in the dropdown cell H2. If it's YES, and the hardware list sheet is more than zero and subtracts two from that value.

Please Login or Register  to view this content.

You can view the code by right clicking on the check list tab and selecting View Code.