I have a workbook with multiple sheets. On the different sheets there are multiple columns of data all set up with a column of dates along side them.
199901 | 3.5
199902 | 4.2
199903 | 6.2
On the first sheet are statistics that I've incorporated into a macro to automate chart creation. On the second sheet there are 3 sets of columns. The first set has the date in annual format, the second in monthly format, and the third in quarterly format. There is a designation for what the format the date is in on the first worksheet.
I am looking for a way to search a column (C1:C13 usually) on sheet1 to find a cell containing one of the three formats (Monthly, Quarterly, Annual) and then go to the first numerical value in the column and then go through the corresponding column on the second sheet and find that value to start a chart range.
If anyone can help with this I'd be very grateful, I can't seem to find an example that does this, and when I try to combine code I've seen elsewhere I don't get the results I'm looking for.