Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup
I need a macro that will do the following: Run the autofilter for column E specifing that the data be greater than or equal to A and less than or equal to IZ (thats the letter i, not L). Further it then goes to the workbook called mailing.xls (which will already always be open) and selects the sheet labled A-I. Then it goes back to the original workbook (named IF.xls) and selects the first of the autofiltered rows in column A (which is record #). It copies the data in column A and searches for it in Column A of mailing.xls. After the matching row in mailing.xls is found, it then goes back to IF.xls and copies the data from a column whose heading is labled CODE and pastes only its value into the column labled Code1, 2, 3, 4, 5, etc (as defined by a cell labled CODECOL). So what this means is before I run the macro I type in CodeX (x=1-10)into a cell that i defined to be CODECOL and when the macro is run it copies and pastes the codes from all of the records in the IF.xls autofilter to their counterparts in mailing.xls but it pastes those codes only in the specified column, by CODECOL. Finally after it completes all the rows that were found by the autofilter, it changes the autofilter in column E to be greater than or equal to J. Further it runs the same stuff as above, but this time it only searches the worksheet labled J-Z in mailing.xls. Thanks (ps. can't use formula's for this, i know index and match will do the trick but i can' t use it for various reasons) -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup
Well I'm not in school, I am working on this for work. I have written a formula for this in excel but it makes the file much too large for it to be pratical. But you are correct, I am not prepared to really learn VB for this one thing that I need to be done. If you think you can write something for me that will do this I would be willing to spend up to $40 for it. Thanks Don Guillett wrote: Sounds more like you want someone to do a project for you instead of answering a question. I need a macro that will do the following: [quoted text clipped - 27 lines] (ps. can't use formula's for this, i know index and match will do the trick but i can' t use it for various reasons) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200508/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |