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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with simple macros for double checking manual plugs
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with simple macros for double checking manual plugs
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with simple macros for double checking manual plugs
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" wrote in message ... 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with simple macros for double checking manual plugs
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. -- Regards, OssieMac "JLGWhiz" wrote: 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" wrote in message ... 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 . . |
Reply |
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 |