Edit existing macro

[Seeboo]

Hello,

I have a file with macro, which unfortunately does not work because I added a new column "Accesories". I do not know how to change macro... Can anyone help?

The second thing that I would like to after click on the START button was also the values for the column "Accesories",(vertical search model.suffix and return from column C from "model list" sheet.

[gmr4evr1]

I downloaded your sample, and it worked perfectly fine manually and by clicking start.

[jaslake]

Hi Seeboo

You can try this but I don't really know what the ElseIf Code is doing

Please Login or Register  to view this content.

[xladept]

Hi Seeboo,

Here's alternate code for your routine:

Please Login or Register  to view this content.

[Seeboo]

Hello,

I am very grateful to all for your help.

Big thank you!

[xladept]

You're welcome and thanks for the rep!

[Seeboo]

Hello again,

xladept,

I need some support... I noticed this issue just now... it is about column "F" in Plan sheet. Macro returns only one value but sometimes there is more than one (example: 32LB580U-ZM.BEEMLJP).
What is the fuction for return all results not only one?

[xladept]

Hi Seeboo,

Try this:

Please Login or Register  to view this content.

[Seeboo]

I do not know what is it but macro ommits some rows... please look at the attachment.

[xladept]

Sorry Try this:

Please Login or Register  to view this content.

[Seeboo]

Excellent! Thank you !

[xladept]

You're welcome and thanks for the rep!