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)


--
Message posted via http://www.officekb.com

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"Derek Y via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
>
> 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

[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


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