I have searched everywhere on Google for the last 2 hours for a solution to no avail. Basically if 2 specific criteria are met, I need the value changed in another cell. My spreadsheet fluctuates daily and can have up to 50,000 rows.
Column C is my model #. I am looking for a specific model #.
Column E is my warehouse, it is either 000 or 100 and the model could be in both.
Column F is my quantity on hand for that model in that warehouse.
What I need is, if if a specific model is found and it is a specific warehouse, then subtract x from that quantity on hand. And I need this for 10 different models in warehouse 000 and 15 different models in warehouse 100. Any help for VBA code for this would be extremely helpful.
Column C is my model #. I am looking for a specific model #.
Column E is my warehouse, it is either 000 or 100 and the model could be in both.
Column F is my quantity on hand for that model in that warehouse.
What I need is, if if a specific model is found and it is a specific warehouse, then subtract x from that quantity on hand. And I need this for 10 different models in warehouse 000 and 15 different models in warehouse 100. Any help for VBA code for this would be extremely helpful.
