I'm writing a macro and need to select the cell that intersects with the column of a specified Emp ID and the last row in column A with text.
Both the date in Column A and the Emp ID are being pulled from another worksheet.
For instance, I have inserted 09/05/2006 in A13 and need to find the column that contains the specified Emp ID. So given the Emp ID is in D1, I need to select cell D13.
Another example, I have inserted 9/08/06 in A14 and the Emp ID is in column P. I need to select cell P14.
I hope I've explained this correctly. If someone could just give me a headstart on how to accomplish this I can tweak it to fit my needs.
Thanks for your help!!!
Both the date in Column A and the Emp ID are being pulled from another worksheet.
For instance, I have inserted 09/05/2006 in A13 and need to find the column that contains the specified Emp ID. So given the Emp ID is in D1, I need to select cell D13.
Another example, I have inserted 9/08/06 in A14 and the Emp ID is in column P. I need to select cell P14.
I hope I've explained this correctly. If someone could just give me a headstart on how to accomplish this I can tweak it to fit my needs.
Thanks for your help!!!