Copy a range and paste special to first available row in another range

[MariaPap]

Hello

I have data in range s3:y. I get these data using formulas.

I need a macro that will copy and paste special(only values) to first available row in range A:G

Can you pls help me on this?

Thanks in advance for any assistance!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[MariaPap]

Thank you.

Your code does 90% of what i need.

The problem is that also copy the rows that looks like empties but they have in their formula the = IFERROR(FORMULA),"")

Can we do something for this pls?

[JOHN H. DAVIS]

Can you attach a sample with some dummy data?

[MariaPap]

Hello

Thank you for your interesting! I made a small example sheet for you and here it is!

[mngrshoaib]

Dear
try this one...... Sorry dear it doesn't paste values where u required.....

[MariaPap]

Dear
try this one...... Sorry dear it doesn't paste values where u required.....

Thank you for your efford but as you said this is not what i need!

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[MariaPap]

This works great, Thank you!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.