Excel Gurus,
I have run into a very strange problem with excel. I am trying to create an MIS sheet to record the personal financial transactions. There is a "Settings" tab which has the list of categories and sub-categories for the type of incoming & outgoing transactions. In the "Settings" tab itself, I then sort them alphabetically, and then use those lists as drop down menus in "Bank Account" sheets using data validation.
Now, the strange part is that, whenever I duplicate the "Bank Account" sheet, the data validation changes in the Sub-categories columns (Col G). The formula remains the same, but the list names used in the formula gets replaced with other list names !!! In the attached file, see the difference in the "Sample Bank Account" and "Sample Bank Account(2)" sheets. Both are duplicate, but the data validation is different
I have no idea why is this happening. Your help is appreciated.
Thanks
Bookmarks