mrxlsx
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 95
Hello,
Good Afternoon,
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.
Thankyou
mrxlsx.
Below is the sample workbook.
http://www.4shared.com/file/5ohkJEPY/dataentry.html
Good Afternoon,
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.
Thankyou
mrxlsx.
Below is the sample workbook.
http://www.4shared.com/file/5ohkJEPY/dataentry.html