Automatically copying data from one sheet to another.

[scokaw]

I want to copy certain cells from multiple rows to a separate sheet, based on the data in one column.

For example, from my Data Sheet, for all the rows that have "2013-10" in the ETF Monthly Report (column AC) column, i want select data copied to the ETF Report Sheet.

I need to run this every month.

A macro or something would be greatly appreciated.

Thank you in advance.

[xladept]

Hi Scokaw,

I assumed that you might have more than one ETF Report on a workbook:

Please Login or Register  to view this content.

[scokaw]

This works perfectly. It's going to make my reporting sooooo much easier.

Thank you very much.

[xladept]

You're welcome!

[xladept]

@ saidul - You are also welcome!

@ scokaw - maybe you should comment out the do loop:

Please Login or Register  to view this content.

Since you probably don't want to append the successive run results.

[HaHoBe]

Hi, xladept,

GoSub for me is a straight NoGO.

Any special reason why you do not use either Autofilter or Advanced Filter but run a loop?

Ciao,
Holegr

[xladept]

Hi Holger,

I often use GoSub, I think it's totally appropriate in this case (a mapping) but I can't imagine how a filter could be utilized in this case. I considered an UDT but only in passing. Could you show me how a filter can be used for this program??