Hi, all the precious minds there ! Been reading through threads of you all and honestly, you people GOT THIS ! Its Peanuts for you.
Well, for me and people like me who, just try to get our occasional Excel problems solved and when fails, find this heaven, Good job you all.
Problem
The Problem is that I wish that whenever I select Car Category from the Drop Down List from any cell in Column "AU" of "Database" Sheet it should bring the corresponding Rent value of that car category, that's being provided in "-Key-" Sheet(Shown Below).
Conditions
1. All the coding has to be in VBA not Excel formulae, so that I don't have to copy paste formula in every new record, instead, whenever new record is added in top row(Coding of which is already set), we just have to select the category front the drop down and it should fetch the Rent for it.
2. On clearing Any Cell in "AU" column of "Database" sheet it should clear its corresponding content in "AV" column of the "Database" Sheet.
Much Obliged for your kind consideration, and support.
BR
Saifierro
Well, for me and people like me who, just try to get our occasional Excel problems solved and when fails, find this heaven, Good job you all.
Problem
The Problem is that I wish that whenever I select Car Category from the Drop Down List from any cell in Column "AU" of "Database" Sheet it should bring the corresponding Rent value of that car category, that's being provided in "-Key-" Sheet(Shown Below).
Conditions
1. All the coding has to be in VBA not Excel formulae, so that I don't have to copy paste formula in every new record, instead, whenever new record is added in top row(Coding of which is already set), we just have to select the category front the drop down and it should fetch the Rent for it.
2. On clearing Any Cell in "AU" column of "Database" sheet it should clear its corresponding content in "AV" column of the "Database" Sheet.
Much Obliged for your kind consideration, and support.
BR
Saifierro
