With Exel 2003:
Sheet 1
<TBODY>
</TBODY>
Sheet 2
<TBODY>
</TBODY>
I want to be able to click on a cell in sheet 1 and get linked directly to a cell with the exact same string in sheet 2. I have just been asked to do this for my boss and I havent touched VB in years! there are thousands of rows in either sheet on what I am working with so I know I cant do it manually. Sorry but I need help and I don't have the time to study for it!
Sheet 1
A | ||
B | ||
C |
<TBODY>
</TBODY>
Sheet 2
C | ||
B | ||
A |
<TBODY>
</TBODY>
I want to be able to click on a cell in sheet 1 and get linked directly to a cell with the exact same string in sheet 2. I have just been asked to do this for my boss and I havent touched VB in years! there are thousands of rows in either sheet on what I am working with so I know I cant do it manually. Sorry but I need help and I don't have the time to study for it!