Hello all,
Good morning,
I have Sheet1 where I have all expenses/payments, say Fuel, Food, Stores etc.
I have other sheets named i.e. Labor, Food, Stores, Domestic, Health etc.
The moment I enter some payment to hospital and select option1 (drop-down data validation), it should go to Health sheet and sit there. If I enter some payment to Fuel and select option2 (drop-down data validation), it should go to Fuel sheet and sit there. Till some extent I have it done good. But If I edit the options selected in the main sheet, concerned changes are not happening in the relevant sheets. The data behaves static, not changing. I used index/match, v-lookup, look-up functions, but in vain, its not working. Please help. Since I am a new user this forum not allows me to send the file link to show you the exact problem case.
Thank you
mrxlsx
Good morning,
I have Sheet1 where I have all expenses/payments, say Fuel, Food, Stores etc.
I have other sheets named i.e. Labor, Food, Stores, Domestic, Health etc.
The moment I enter some payment to hospital and select option1 (drop-down data validation), it should go to Health sheet and sit there. If I enter some payment to Fuel and select option2 (drop-down data validation), it should go to Fuel sheet and sit there. Till some extent I have it done good. But If I edit the options selected in the main sheet, concerned changes are not happening in the relevant sheets. The data behaves static, not changing. I used index/match, v-lookup, look-up functions, but in vain, its not working. Please help. Since I am a new user this forum not allows me to send the file link to show you the exact problem case.
Thank you
mrxlsx
Last edited: