Looking for code to select a row from a large sheet.

[wagmanm]

I have a large chart made up with hundreds of rows and 10 columns on a separate sheet in my workbook. Before trying to do this with excel I would use certain pieces of data to determine the correct row that would provide my answers. I have a series of if statements set up to the point where they will put in X in the 11th column next to the correct row. I would like to have this row then selected and copied onto my "main" sheet so that further functions can be carried out with these data points from the chart. Any help would be greatly appreciated.

[patel45]

can you attach a sample file with data and desired result ?

[HaHoBe]

Hi, wagmanm,

if you put your formulas and Ifs into Column A you could VLookup to get the data, if itīs in Column 11 you might need to use

Please Login or Register  to view this content.

where you would need to alter the name of the sheet and the name of the column from which you would the value to be returned.

Ciao,
Holger

[wagmanm]

Danke! Das is sehr gut! I was getting a sample sheet ready to upload, but what HaHoBe posted does exactly what I needed! Thanks guys