How to enter data conditionally into various sheets?

[mrxlsx]

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.

Thankyou
mrxlsx.

Below is the sample workbook.


dataentry - Download - 4shared - farida perveen

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-questions/706124-conditional-data-entry.html#post3486395

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-questions/706124-conditional-data-entry.html#post3486395

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).