• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Coordinate Categories Named Range



I have 3 worksheets that have Categories: Monthly Analysis, Budget Months, and Categories.

I appreciate any ideas on how to keep these consistent so that if a sub category needs to be changed (edited, added, or deleted) it remains the same in these sheets.

Perhaps a conditional formatting to change the cell color if they aren't all matched.

Also I plan to use this named range in the Transactions sheet as a drop down list. It would be good to not include the blanks or the 'Subtotals'.

Thank you very much for your help