Hi all,
Would anyone be able to advise me.
If i require a form/Questionaire designed like the following
1) A Dropbox that enables me to select "Customer A B C etc" (I know how to do a drop box)
2) with Each selection of customer, the questionaire would either retrieve data already input or an empty form to input.
3) By inputting the answers to the question, it would write/overwrite data into a Master Sheet.
I got some idea from this link http://www.excelforum.com/excel-gene...html?p=3203040
But because of my lack of macros i cannot understand how i can modify it to meet me needs. The macro already have input to master sheet but it only creates input based on how many times u input, it does not fulfil Criteria number 2 and 3
If there is anyway i can do this without Macros even better but im skeptical....
Thanks for the advise, i am including workbooks before and after.
Bookmarks