Hi,

I have to do really basic and boring spreadsheet work, and my boss has
something against VLOOKUP, he doesn't want people in the office using
it.
And he is right, because with these spreadsheet the lookup values are
of mixed type, with dashes, the spreadsheets have lots of formatting,
and there have been many problems.

I would like to write a macro for the following pseudo-code

COPY ITEM
OPEN FINDER
PASTE INTO FINDER
SWITCH SHEETS
SEARCH FOR DATA

Then it stops so I can check that it has found the right lookup value,
it waits for me to press a key to confirm that I have the right value,
and then continue.

DISPLACE X CELLS RIGHT
COPY CELL
SWITCH SHEETS
PASTE INTO SPREADSHEET

Can anybody help me with this? I have tried using the record macro
function, but it always goes between two cell. I have relative
references on.

David