VB Code to copy certain data to another workbook

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown in Column A thru Column S
Column A is the store name, and Row 1 is the heading.
Based on the selection of the store by text "Yes" on column W,
I need to copy data for stores with "YES" in another workbook at the location and name as shown in
cell U1.


Let me know if you have any questions.
Thanks.

Riz

[alansidman]

Why not just filter the data in column A for the Store you want and then do a copy and paste. Fairly quick and no code required.

[rizmomin]

Hello alan:

Yes that would work but I need the code since it will be part of other VB Code.

Please help.

Riz

[jolivanes]

Am I wrong in thinking that you just want someone else to do your work?
I tried to think of an excuse but I can't think of one that someone who has close to 4300 post in this site alone can't put AutoFilter code together.
Count me out.

[maniacb]

The following might work. Check it out. I used VBA Vlookup adn populated Col T with Yes/no, then used autofiler.

Please Login or Register  to view this content.

[rizmomin]

Hello maniacb:

Thanks a lot, this is exactly i needed.
Riz