Automatically fill cells with product specs from another sheet/workbook.

.
For searching, probably VLOOKUP

For populating the customer offer sheet, probably COPY and PASTE.

Thanks for the advice! I've read about VLOOKUP but I'm still pretty new at Excel so I only know how to use basic functions.

I was hoping to avoid copy and paste but it will work for now.

Do you think there is a different software I could use to achieve my goal?

.
Excel will most likely be all that you need. There are other software packages you could use but its kinda like a preference between a Chevrolet or a Ford. Which do you like better ?
From your needs description, again, Excel should suffice.

Understand you are new to VBA programming. That's ok, we all started somewhere. Learning first by reviewing what others have done ... following the logic of the code ... then applying the same in
a project of your own is ok as well. Nothing wrong with that as to tell the truth, most folks borrow from one another at one time or another. If that were not the case, this forum and others like it wouldn't be in
the public domain.

Attached are three examples of Invoices. Some have a product inventory to draw from when filling out the invoice. A search funtion, if needed, could be added to any of these examples, although a simple DATA FILTERING
may very well suffice for your needs. You can expand the project any time you desire and make it as complicated/robust as you want.

Here is an example of code from one of the projects. Review the code, try to understand it, understand the logic and go from there. Confusing at first but eventually you will get it.

Please Login or Register  to view this content.

Thank you again!

While this looks difficult I'm sure I'll get it with enough time. I want to learn as much as I can so that maybe I can engineer a fix myself.