VBA code to change linked cells value on index match

[tony75]

Hi Guys

I've been struggling for a couple of weeks to create something for my work and some of you already helped me at some extend. Because of that, on the last 3 days, I passed from "not knowing at all what VBA is" to "now I have a clue and understand", with the help of 17 hours a day watching tutorials. Attached is my project, nothing fancy but I wrote all the code (I had to start somewhere) but there is one thing I can't figure out. On the Sheet1, the search I make will display the row from sheets "list". that much I was able to do except one thing. when I add a quantity on O9, this will subtract K13 with that quantity, present a result on Q9 and update K13. what I need to complete this, is for the quantity on Sheet "list" to be updated as well. I know it must be very easy for you guys, but I'm 3 days old In VBA!!! I could really appreciate some help, as my brain is starting to hurt.


Thanks in advance

[fshbet]

Hi Tony75,

Check the attachment

Copy of Corona Project.xlsm

[tony75]

Hi fshbet


Unfortunately, it gives me the error "object variable or with block variable not set". Is it something you can fix?


Cheers


Tony

[fshbet]

Sorry Tony75,

just change the code in Module1 to this

Please Login or Register  to view this content.

[tony75]

Hi fshbet


That worked marvellous you Sir, are a genius!


Thank you so much for your help.

Tony