Good afternoon - Am just learning VBA for excel and am stumped on creating macro in excel 2016. I have developed a workbook that contains 24 different worksheets. For each of these worksheets, in column "K", I have a drop down list of "YES" and "NO". When the user selects "NO" for each row in the worksheets, I want it to copy the cells " B, D and J" for that row and paste the information into another table located in another worksheet, location "B, C and D" on first available row.

The 24 worksheets are named differently than the 24 tables located on the main worksheet. I have built the main worksheet "MONTHLY GOE RECONCILIATION" with 24 separate tables. I have several other macros that work on the 24 separate worksheets, so not sure how to write the code to use which name (tab name or table name listed under "design". The main worksheet named above has the 24 tables, each named with a different table name under "design" and an assigned tab name. (Hope that makes sense!).

The purpose of this workbook is to manage the monthly General Operating Expenses and to only post on the main worksheet (MONTHLY GOE RECONCILIATION). Those items listed as "NO" from the 24 separate worksheets as "NOT RECONCILED".

If anyone can help me out, that would be great! I can post the various names for the worksheets if needed. My research so far has led me to believe that I would need to put this code in each of the 24 worksheets.

My workbook has sensitive data in it, but I can clear it out if you need me to email you the workbook for review.



Thanks