Copy paste macro that change row if it's filled

**xatomicx** · 04-23-2017, 08:57 AM

Hi everyone,

here's my macro

Please Login or Register  to view this content.

This macro copy data to A2 in Trends.

I want the same, but if A2 is full, it paste to A3, and so forth. how can i do that?

**sintek** · 04-23-2017, 12:12 PM

Hi xatomicx

Give this a try:

Please Login or Register  to view this content.

**davesexcel** · 04-23-2017, 12:21 PM

Try this,

Please Login or Register  to view this content.

**xatomicx** · 04-23-2017, 01:03 PM

Thanks davexcel version works

Sintek too, but not if no data is in A2.

**sintek** · 04-23-2017, 02:05 PM

but not if no data is in A2.

@ xatomicx
Please explain...so I know where to correct....Sample file attached works fine.
@ davesexcel

Thanks, completely forgot about

Please Login or Register  to view this content.

Re: Copy paste macro that change row if it's filled