• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to enter data conditionally?

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
 
Back
Top