User Input Form

Hi,

With the help of this forum i learnt a lot and managed to create enclosed sheet to my satisfaction.

This sheet is a sales pipline/ achivement tracking vis a vis targets for a group of people reporting to me. I tried to creat the same in access but wasnt succesful thus created it in excel.

Finally i need help in creating a user input form for "pipeline input sheet" which would:

1. Open as popup on opening the file
2. will have all the feilds as in the sheet.
3. would really appreciate if some one could make it menu driven like in access with options like: New Record / report / save or auto save on exit/ exit. also as tis work book would be a shared sheet among multiple users so it should be able to act the same way.
4. Any other suggestions i can make this sheet take less space/lighter and more user friendly.

hi,

I did check that out thru your previous forum reply but could not understand the same. i am a dud in VBA. if you could guide me to something which is like step by step i would be greatful.

regards