how to select range of values from excel sheet and write to different workbook

[kottam_reddy]

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

[tom1977]

Hi

Good idea will be send by You excel file with sample (and the resoult You expect)

[NickyC]

Tom is right - an example would help.

This might get you started. to make this work

1. Have the values you want to check in a named range called “values” on the first sheet of your workbook
2. Select the cell within the “values” range with the value you want to look up

The macro will input in rows from row 1 on the second sheet of your workbook:

• The value of the selected cell in column A
• The value from column 1 of that cell's row (representing the x coordinate) in the second column
• The value from row 1 of that cell's row (representing the y coordinate) in the second column

Please Login or Register  to view this content.