Hi,
I have one work book(sheet) having M number of columns and N number of rows. First row represents X co-ordinates and first column represent Y co-ordinates.
I need to select one value. for example value P located at N*M location. I want to search all the values equal to P and its X and Y co-ordinates and write to different sheet.

I am new to excel macro programming.. if you give idea how to write macro to do this, it will be really help full for me .. Thank you in advance