Need Help to make Quote with vba code ^^

Hello at 1st

I'm trying to make Quote with vba but i can't
i have a sales sheet and a Quote sheet , what i need is to take the Quote data from the sales sheet , You will understand better if you look at the sheet
if that can be done with a command button like "pricing" or something it would be great :D .
Thanks

Originally Posted by gostavee

if you look at the sheet

But you forgot to attach the sample workbook

In M2 Cell of sales Shet

=L2&K2


Drag it down...


In D14 Cell of Quote Sheet


=IFERROR(INDEX(sales!E:E,MATCH(B8&B14,sales!M:M,0)),"-")


Drag it down...


Refer the attached file

There is no need of VBA or command buttons are needed for this simple task since we can go for another alternate formula which don't need any supportive column in source sheet.

In D14 Cell of Quote Sheet


=IFERROR(LOOKUP(2,1/((Customer=$B$8)*(sales!$K$2:$K$13438=$B14)),sales!$E$2:$E$13438),"-")


Drag it down...

Originally Posted by gostavee

Cool :D , but it gives me an error on "(2,1/ " i don't know why

Formula included in the attached file for your easy reference