Lookup

[Derek Y via OfficeKB.com]

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)

 

[Don Guillett]

Sounds more like you want someone to do a project for you instead of
answering a question.

 

[Derek Y via OfficeKB.com]

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

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)