My first worksheet has rows with each one being a summary of data gathered from a single chart in another worksheet. The second worksheet contains a number of charts each one is designated a different date. How do I tell one of the rows in the first worksheet to search for a chart in the second by date, and then in that chart choose a certain cell that is for example 3 colums over and 5 rows down from the cell where the date is located? Thank you much!
Bookmarks