Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with simple macros for double checking manual plugs
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FYI - MS Plugs 7 XL Flaws | Excel Discussion (Misc queries) | |||
Checking for double entries | Excel Discussion (Misc queries) | |||
Checking for duplicates - think this is simple | Excel Discussion (Misc queries) | |||
Simple Error Checking | Excel Programming | |||
Create simple commandbutton for manual recalculation | Excel Programming |