Need help with a copy paste loop

[copleyr]

Hello,

I'm desperate for a copy paste macros that will:

1) Copy H3:H143 (141 rows) from "Sheet 1" and place this on "Sheet 2" on D4:D144 (141 rows)

2) Copy I:3:I143 (141 rows) from "Sheet 1" and place this on "Sheet 2" on I4:I144 (141 rows)

So, in essence, it will copy every single column across on "Sheet 1", but will paste every 5 columns on "Sheet 2" .


I then need this to loop 33 times to continually copy and paste across columns.


Can I make this happen?

Thanks in advance for your help!

[JBeaucaire]

This should do it:

Please Login or Register  to view this content.

[copleyr]

Awesome JB that was great. Worked perfectly.

I just realized I'm not completely finished with the macros I need.

With that, I also need the same "Sheet 1" information pasted to "Sheet 3", "Sheet 4", "Sheet 5", and "Sheet 6". In the same format (every single column across on "Sheet 1", but will paste every 5 columns on "Sheet 3", "Sheet 4", "Sheet 5" and "Sheet 6"


With that in mind, as the financial data is "Sheet 1" is copied, I need it to be pasted 3.5% higher than it was copied from.........So that Sheet 2 will be 3.5% higher than sheet 1, Sheet 3 will be 3.5% higher in sheet 2, and so forth.


Any suggestions?

Thank you

[Leith Ross]

Hello copleyr,

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!