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
Bookmarks