Where can I find advice or a tutorial for creating a variable from
selected cell contents, i.e. from the clipboard content.

I have a relative macro that captures a string from one worksheet and
searches for the string in a second worksheet.

On finding the string in the second sheet, it returns to the
first sheet and picks up the sting in an adjacent cell and returns to
the second sheet and pastes the second string into a cell adjacent to
the 'found' cell.

The macro then returns to the first sheet and moves down one row,
preparatory to repeating the capture/switch/search/ etc routine.

It would be much simpler to make variables of each of the two strings
in the primary sheet , switch once to the secondary sheet, search for
the matching string with the first variable and than paste the second
variable into the adjacent 'found' cell.



Lindsay Rollo
Wellington, New Zealand

Sounds like you are trying to do a VLOOKUP or INDEX/MATCH - look for
these in Excel Help - so why not just enter a formula and copy down?

Hope this helps.

Pete

On Oct 21, 11:43 pm, wrote:
Where can I find advice or a tutorial for creating a variable from
selected cell contents, i.e. from the clipboard content.

I have a relative macro that captures a string from one worksheet and
searches for the string in a second worksheet.

On finding the string in the second sheet, it returns to the
first sheet and picks up the sting in an adjacent cell and returns to
the second sheet and pastes the second string into a cell adjacent to
the 'found' cell.

The macro then returns to the first sheet and moves down one row,
preparatory to repeating the capture/switch/search/ etc routine.

It would be much simpler to make variables of each of the two strings
in the primary sheet , switch once to the secondary sheet, search for
the matching string with the first variable and than paste the second
variable into the adjacent 'found' cell.

Lindsay Rollo
Wellington, New Zealand