Avatar of spudmcc
spudmcc
Flag for United States of America asked on

Excel VBA Script to find a cell and replace a different cell with a value.

Hi Experts

I am in need of some help with a VBA script please.  I have a single workbook with a tab labeled "final".  

First thing I need to do is in Column "D" find two different values 123 and 456.  There will be no dupes and these are unique to that
column.  Find each of the values and change whatever value is in Column F (of the same row as the column D value) to 30-03-01.

Second thing on this same tab.  In column D find "BB1224" and whatever value is in column I of the same row subtract 30.  

Any help would be so greatly appreciated.

Andy
Microsoft Excel

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
spudmcc

ASKER
Thank you for your quick response.  This works perfectly.  

I so much appreciate you sharing your time and knowledge.  

A
Subodh Tiwari (Neeraj)

You're welcome. Glad I could help.
Thanks for the feedback.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck