I have a need to create a catalog in Excel that will list a number of products.
Each sheet will be for a separate category, and there will be a checkout page.
The user will browse the catalog and click to select items.
These line items will then be copied over to the checkout page and the user will then be able to insert credit card info, delivery details before finally doing 2 things:
1. Create an order file and attach it to an email - that will be formatted using default email on the pc (inc email address, subject, message body)
The user will then be able to save/delete the order as required.
OR
2. If the order is to be sent later, or needs to be transferred to another pc, then a order file is created in a special directory.
This spreadsheet is intended to be used on ships that users will not have access to Internet browsing - they can send email OK.
I have included a sample Excel spreadsheet that should show what is required.
*** This is basic VBA programming - we do not need the graphics part doing, just the basic functions on the order process.***
If you can suggest simple ways to import data into the catalog that would be welcome.
Thanks