Hi there :-)
I'm creating a Purchase Order Form that will reduce time spent adding in contact details.
What I'm looking to achieve is a form that will be printed with a few formulas allowing sections of the form to be filled out automatically once a singular company name (chosen from a drop-down list I created, currently with a 'Combo box ActiveX') then the rest of the form is filled out accordingly.
At the moment it's a bit of a mess, not too sure where I'm meant to put the ranges.
There are currently 2 sheets - Sheet 1 with the form, Sheet 2 with all contact information.
Have been googling far and wide for some sort of help, but I'm not the best Excel Wiz, so have resorted to posting a thread, (my first :-D)
Any help would be greatly appreciated, I have attached what I have so far.
Bookmarks