Alan Downie
New Member
Good Day
I have a WS where col A contains dates in rows 2 and down and col B etc. contains data relevant to the date row. The sheet is quite large and I often need to go to a cell within the body of the sheet (similar to the go to function where you enter the cell ref.) The difficulty with the go to function is that I do not know the date ref until I find it.)
I have a small macro that prompts me to enter the date to be found and then makes the active cell (Col A row 999 for instance) returning the date asked for.
What I would like to do is be prompted for the date and then be prompted for the column ID (such as CG) and then make the active cell the intersection of the date row and column data according to my selection.
I hope this makes sense and I bless you and thank you in advance for any help you may be able to give me.
I have a WS where col A contains dates in rows 2 and down and col B etc. contains data relevant to the date row. The sheet is quite large and I often need to go to a cell within the body of the sheet (similar to the go to function where you enter the cell ref.) The difficulty with the go to function is that I do not know the date ref until I find it.)
I have a small macro that prompts me to enter the date to be found and then makes the active cell (Col A row 999 for instance) returning the date asked for.
What I would like to do is be prompted for the date and then be prompted for the column ID (such as CG) and then make the active cell the intersection of the date row and column data according to my selection.
I hope this makes sense and I bless you and thank you in advance for any help you may be able to give me.