Assistance Required, VB and table Lookups

**Luciferlicks** · 07-03-2011, 08:14 PM

I'm building an Excel app for my new business (LED Lighting) which will enable me to collect site survey data (DataCollector), and then I click on a button(Send to Quote) which will populate a "Quotation" tab with a list of products to order based on the site survey data.

The Quotation then has a LOOKUP on a "pricelist" tab, to find the relevant unit price of the product, and complete the Draft Quotation to be reviewed prior to sending to a prospect.

I was hoping someone could help me with this "button", in that I've looked at the logic so many times now and cannot find the fix ? The first four(4) line items in my quote has the wrong price ? It appears my LOOKUP is faulty but I cannot see where ?

It is in Excel 2010.

Kind Regards,
Leon

**stanleydgromjr** · 07-03-2011, 10:54 PM

Luciferlicks,

I just looked at your workbook.

FYI - your VBA Project macro code is locked/password protected.

**Luciferlicks** · 07-04-2011, 03:04 AM

freedom10

Hope this helps

**stanleydgromjr** · 07-04-2011, 09:13 AM

Luciferlicks,

I just looked at your workbook again.

FYI - your VBA Project macro code is locked/password protected.

**Luciferlicks** · 07-08-2011, 02:45 AM

I'm building an Excel app for my new business (LED Lighting) which will enable me to collect site survey data (DataCollector).

I then click on a button(Send to Quote) which will populate a "Quotation" tab with a list of products(Pricelist tab) to order based on the site survey data.

The Quotation then has a LOOKUP on a "pricelist" tab, to find the relevant unit price of the product, and complete the Draft Quotation to be reviewed prior to sending to a prospect.

I was hoping someone could help me with this "button", in that I've looked at the logic so many times now and cannot find the fix ? The first four(4) line items in my quote has the wrong price ? It appears my LOOKUP is faulty but I cannot see where ?

It is in Excel 2010.

Kind Regards,
Leon