Hi All,
A client of mine asked me if I could help with an order form he created in Excel.
He has an order form on sheet 1 with sheets 2-10 having a list of different types of parts he stocks (with quantities and price).
He wants his customers to be able to pick and choose parts from any sheet and they auto populate on sheet 1's order form AND then they click a button to email the completed order form to him.
Before I even think of doing anything, I was just wondering, would this type of job involve a lot of VBA (as I assume check boxes will need to be used) or is there an easier way to achieve this by just using lookup type formulae? Or maybe by using Data Validation Lists???
Or is this a job more suited for Access?
I've got a feeling this is going to be way beyond my knowledge...
Thanks.
A client of mine asked me if I could help with an order form he created in Excel.
He has an order form on sheet 1 with sheets 2-10 having a list of different types of parts he stocks (with quantities and price).
He wants his customers to be able to pick and choose parts from any sheet and they auto populate on sheet 1's order form AND then they click a button to email the completed order form to him.
Before I even think of doing anything, I was just wondering, would this type of job involve a lot of VBA (as I assume check boxes will need to be used) or is there an easier way to achieve this by just using lookup type formulae? Or maybe by using Data Validation Lists???
Or is this a job more suited for Access?
I've got a feeling this is going to be way beyond my knowledge...
Thanks.
