Completely new to excel VBA, sorry if this seems pretty standard, no idea what I'm talking about
Want to be able automate the look up of a piece of data in a spreadsheet, then subtract/add a value from the cell adjacent to it.
E.g. I want to change the price of an item in a stock list by $0.25
I enter the name of the item in Worksheet 1, A1 and the price change of $0.25 in A2
I then want to identify the item name in Worksheet 2, Column A, and subtract A2 from the adjacent cell in column B
Thanks