I want to have a webpage that vendors can log into. On this page there would be an embedded excel file that we use currently. This is a fill in the blanks page with some drop down menu's, does a little math. When the submit button is clicked a copy would be emailed and saved for that person to view at any time. There will be 30+ vendors logging in and I do not want them to see each others information.

Ultimately, I will be able to do reports on anyone, but they can only do reports on themselves.

 

Is this scenario possible? I have not had much luck so far and don't want to invest more time if it is not.

 

Thanks for any help.