Hi All,
I need some help with what I thought would be an easy solution. FYI, I have posted this question already on Mr Excel ([http://www.mrexcel.com/forum/excel-q...ue-another.htm). They were terrific, but I didn't quite get an answer there, so if it is OK, I would like to ask the same question here.
I need to be able to click a button on the sheet, and have a macro that takes me to the corresponding cell that matches the text in the ACTIVE cell. I don't need it to do anything once I am there, just get me there so the user can see what is going on.
Example: If the active cell is D6, and contains the date "06 June 2015", then I want the macro to take me to the cell in Row D that matches that date. Similarly, if I am in E256, and that text is "12 Dec 2015", then I want to be taken to the corresponding cell in Row H that matches E256.
It will only ever need to look within the row of the active cell, never in another row.
The important thing is the found cell could be in any column but will always be based on the contents of the active cell of that row. The cell that I need to find will be one of the 365 cells (one for each day of the year) within that row that follow the active cell. There will never be any duplicates either, because each cell contains unique info (date)
The active cell will be either Column Dx or column Ex (where x represents the row number).
I really hope this makes sense. I need to present this solution to the CEO tomorrow, and I underestimated the apparent difficulty of this task.
And I am sorry if I have repeated my self a few times in this post, but I want to be as clear as I can to avoid confusion and wasting your time.
Any help would be greatly appreciated.
Cheers
WT
Bookmarks