Hi'
I have three questions...please help and guide me.
1) Make a sheet (let us call it A) like in a survey - where people fill in different text boxes and thus provide different information. I took a look at VB, but am novice and need a lot of guidance and help. Ideally every submission would have its own file.
2) The sheets (A's) made above need to be collected and stored, like in database. I need to do it so simple thus people dont need to anything else then submitting the sheet "A".
3) I need to be able to search throught the collection of the sheets and make it visible. So if we call the "search sheet" for B. I need this B to be able to search among the sheets, but with possiblity of varying the parametres. E.g. searching on the duration, budget, free text key words, application, etc. When the search is complete, one should be able to choose one of the A-sheet and open it by pressing a button. Maybe filters can be used effectively - if it is easier?
I would like to point out - that I would like if possible this in one file and have two files, like one for submitting A and one for search, B.
Simply the process would be
i) A is filled and submitted by a user
ii) The submitted sheets will be collected in one place.
iii) B allows search among A-sheets.
I have three questions...please help and guide me.
1) Make a sheet (let us call it A) like in a survey - where people fill in different text boxes and thus provide different information. I took a look at VB, but am novice and need a lot of guidance and help. Ideally every submission would have its own file.
2) The sheets (A's) made above need to be collected and stored, like in database. I need to do it so simple thus people dont need to anything else then submitting the sheet "A".
3) I need to be able to search throught the collection of the sheets and make it visible. So if we call the "search sheet" for B. I need this B to be able to search among the sheets, but with possiblity of varying the parametres. E.g. searching on the duration, budget, free text key words, application, etc. When the search is complete, one should be able to choose one of the A-sheet and open it by pressing a button. Maybe filters can be used effectively - if it is easier?
I would like to point out - that I would like if possible this in one file and have two files, like one for submitting A and one for search, B.
Simply the process would be
i) A is filled and submitted by a user
ii) The submitted sheets will be collected in one place.
iii) B allows search among A-sheets.