Hi..I'm just discovering the wonders of macros. I have the minimum-est possible programming knowledge. I would greatly appreciate a macro code to tackle this cumbersome task:
i.e. Selecting B1 that contains 1A will take me to cell location in Column A that contains 1A and vice versa.
Help please..!
- Say B1:B10 contains strings 1A-10A in its counting order. (My spreadsheet has 100-1000 of these)
- Column A in the same spreadsheet contains the same strings
i.e. Selecting B1 that contains 1A will take me to cell location in Column A that contains 1A and vice versa.
Help please..!