LUIS FREUND
asked on
Changing Cell value based on a criteria in Excel
Per the attachment I want to change the value of a cell based on the value from another sheet. Also wanted to mention that the data is linked to access and updates on open.
So for example per the attachment: on rows 7 thru 12 on column H that is highlighted I wanted the NO's to be YES since the base number (number without the dash) on the CTF_ALL sheet has a Yes.
So if 930-45588-1 on the OPEN_REQ_PLM_COMPARE is NO but on the CTF_All Sheet the base part number 930-45588 is a YES than I wanted the NO's on column H (one's highlighted in yellow for example) to be converted to YES's.
I have many thousands of lines so that's the reason for the request.
C--Users-lfreund-Desktop-CTF-REVISI.xlsm
So for example per the attachment: on rows 7 thru 12 on column H that is highlighted I wanted the NO's to be YES since the base number (number without the dash) on the CTF_ALL sheet has a Yes.
So if 930-45588-1 on the OPEN_REQ_PLM_COMPARE is NO but on the CTF_All Sheet the base part number 930-45588 is a YES than I wanted the NO's on column H (one's highlighted in yellow for example) to be converted to YES's.
I have many thousands of lines so that's the reason for the request.
C--Users-lfreund-Desktop-CTF-REVISI.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER