I'm currently trying to figure out a way to create a from using this as a template:
The usage of this would be the user could search for the product and it would auto fill the data. they could also add another part in using this same form.
now currently this is just an excel template of what I would like for it to look like. the giant blank spaces are for pulling pictures and such. i'm not entirely sure my question makes since but if you need me to clarify a bit more i can try. I'm looking for anyway for this to be possible weather it be a formula or a macro. again though as I said i'm not sure this is possible using excel or even the dreaded access.