Hi,
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
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