rkspeaks
Member
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.
Here is my sample workbook link.
http://hotfile.com/dl/225713552/a94361d/CondSum.xlsx.html
Thankyou
RK
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.
Here is my sample workbook link.
http://hotfile.com/dl/225713552/a94361d/CondSum.xlsx.html
Thankyou
RK