Hi all
I have a worksheet size roughly 100 * 400 cell.
there is roughly 100 cells filled with RED color and with different value.
When i used FIND ALL format - RED, I can locate the cell location and the cell value.
And I wish to copy these 2 info onto a new sheet so that on the new sheet, I can create a hyperlink and easily access to the location of the RED cell.
However, in FIND and REPLACE, i have a list of results on what I want. But i cannot copied the information out.
So is there anyway to copy it out or to achieve what i want?
For eg.
RED value cell 50 A3 87 D71 251 AQ5
and so on.
Thank you.
Bookmarks