Posts by kaireikia

fixed myself, thank anyway

Can you please check attached? I made changes in yellow, you will understand what i mean after run VBA

Dear Brian, you done a great job, thank you, now i need to find out how to make changes on VBA to have possibility to add/fill/replace items on the lists with different names (i've tryied to change one set on the list but get error), i have now about 200 specifications and list is growing

Hi, in this case, it is not important, I can delete them after.

Sample book :

Hello, I have a sheet with values model1, model2, model3... etc. I need VBA to find these models and replace them with prepared lists in other sheet based on model name (items and qty). Like sample, find model1 in column A, replace within column A: item1, column B: qty, then A1=item2, B2=qty.
Maybe someone has the same issues, or just can help with this?