a macro that looks up two rows of data and selects cells based on a certain condition

[can2c]

Hello

I have two rows of data. In row 1, I have year1, year2, year3 etc. Directly underneath in row 2, some cells contain numbers and some contain N/A. What I want to do is create a macro that will look up the values in row B, select only those cells that contain numbers and set the range equal to x. Then I want it to select the cells in row A that correspond to the cells in row B that contain numbers, and set this range equal to y. This is so I can make a line graph of x against y. Does anyone have any idea on how to do this? I've attached a workbook with some numbers if it makes things clearer.

Thanks

[Palmetto]

You would be better served, IMO, with the data placed in two columns and then use AutoFilter to hide the rows the #N/A values. Excel does not plot hidden rows or columns. No macro code is required. (You can keep your current format if and hide columns manually - placing the data into rows facilitates hiding using AF).

See attached.

[can2c]

that is a good suggestion, but the problem is, in the second row of data it may be that cells 1-5 contain numbers and the rest are N/A, or cells 5-12 contain numbers and the rest are N/A etc. It will change, so I wanted to avoid having to do something manual, which with the filter would mean reselecting the values that I want to show.