Need help with simple macros for double checking manual plugs

[duadinam]

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

 

[OssieMac]

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?)

 

[Shane Devenshire]

Just a little comment - generally you can handle almost anything with
VLOOKUP. But you would need to tell us what exactly the problems are.

Of course - go for the macro.

 

[JLGWhiz]

You are doing better than I am, Ossie, I couldn't interpret Finder. How do
you paste into it?

Some people get paid for doing these kind of projects.

 

[OssieMac]

To JLG Whiz,

"I couldn't interpret Finder. How do you paste into it?"

I interpreted that as how the OP would do this manually. Select and Copy a
cell -> Open Find dialog box -> Paste into the Find what field.


To David,

If my interpretation above is not accurate then perhaps more explanation on
that part also. I am assuming from what you have posted so far that the code
will be relatively simple but just need answers to the questions.