i need to create a macro to find a cell based on the value of other cell.
for e.g. i want find the cell by copying cell "DH1" (in which there is a formula say - "Today()" and it changes every day) and open search box ('Ctrl' + 'F') and paste it there and then click "Find next" then close the search box.
Can you please help me how to record a macro to do this task
How to create a macro to find the value in specified cell