Noobllianz
New Member
- Joined
- Jul 1, 2018
- Messages
- 18
Hi everyone.
Thank you for taking time to look at my post.
I will explain my predicament in detail.
End result : create a fillable excel form/calculator which will automatically extract data from certain cells to fill a genetic quote template.
My plan :
1. Create a fillable data form, locked except input cells.
2. Connect said input cells to quote from where it needs to be filled. Like mail merge?
3. Learn vba to create a button on initial form "generate quote" if required by user.
4.
Here is the place I don't know how to start.
I would like the form to be on a single worksheet.
I wish to create a category/tab on top of page.
E.g (quotation/invoice/certificate)
When clicked into these individual tabs, the static page will upload the relevant information.
Similar to a website page where the top navigation bar is static.
Can someone please advise how I could make this websiteesque design for my project.
Thank you very much for your help!
-B
Thank you for taking time to look at my post.
I will explain my predicament in detail.
End result : create a fillable excel form/calculator which will automatically extract data from certain cells to fill a genetic quote template.
My plan :
1. Create a fillable data form, locked except input cells.
2. Connect said input cells to quote from where it needs to be filled. Like mail merge?
3. Learn vba to create a button on initial form "generate quote" if required by user.
4.
Here is the place I don't know how to start.
I would like the form to be on a single worksheet.
I wish to create a category/tab on top of page.
E.g (quotation/invoice/certificate)
When clicked into these individual tabs, the static page will upload the relevant information.
Similar to a website page where the top navigation bar is static.
Can someone please advise how I could make this websiteesque design for my project.
Thank you very much for your help!
-B