Hi,

Need more information.

COPY ITEM (What is the name of the worksheet to start?)
OPEN FINDER
PASTE INTO FINDER
SWITCH SHEETS (What is name of worksheet to switch to?)
SEARCH FOR DATA (Is the data in a specific column/range? If so, what
column/range?)

Find option: (Match entire cell contents or any part of cell contents?)


"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." (What do you want the do to do if NOT the right value? -
Terminate processing; go back to original worksheet; allow you to select the
right value; other)


DISPLACE X CELLS RIGHT (Do you mean move across X cells? If so, what is X
value)
COPY CELL
SWITCH SHEETS (Switch to what sheet name?)
PASTE INTO SPREADSHEET (Paste where in the spreadsheet?)

--
Regards,

OssieMac


"duadinam" wrote:

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
.