PDA

View Full Version : [SOLVED:] Multiple find and replace in Excell sheets



p30soft
09-07-2020, 06:22 AM
dear experts
i want to know is blow scenario possible to do in excell with VBA helping:


i have C2:D2:E2:F2 values in sheet1 they should be find from all cell of sheet2
then replace C13:D13:E13:F13 values in sheet1 with all cells of sheet2 that have same value


then i need to know how much value changed in any value


is it possible to write this VBA code?