a question

[gidozel]

hi all,
i have one file with 2 sheets. right now i manually copy a certain value from sheet 1, press ctrl+F on sheet 2, paste the value, and if i find it on sheet 2 i color the cell where it was found.
can you help me? i have more than 400 values a week (letters+numbers) to test.
thanks alot, Gidi

 

[dave3009]

Press Alt+F11 to enter the VBE, on the left you will see a list of the open workbooks projects and associated sheets, locate the project you are working on and right click>>Insert>>Module, now paste in the code.

Return to your workbook by either closing the VBE or selecting it from the taskbar. Now press Alt+F8, click on the macro you want to run and press Run, job done.

Some editing may be required so please feel free to post back

 

[gidozel]

WOW THANKS!!!
it's working beautifully!!!!