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?
Need to find values and change to prepared lists
- kaireikia
- Thread is marked as Resolved.
-
-
-
Sample book :
-
Do you really want to replace the rows on the Models sheet or would you like to keep the Models sheet and have an Output sheet that contains the item listing?
-
Hi, in this case, it is not important, I can delete them after.
-
See if you like what the attached file does.
-
-
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
-
Can you upload a sample of what you're trying to do and how you want it to look? You should be able to change the "item*" labels without any problem, but if you change the "Model*" names on the Models worksheet, you need to also change them on the Item list sheet, or the macro won't find them. What is the error you are getting?
-
Can you please check attached? I made changes in yellow, you will understand what i mean after run VBA
-
fixed myself, thank anyway
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!