Cut and paste across sheets

**gigz42** · 06-28-2011, 04:31 PM

I have a range of cells that I add data to on a weekly basis. At the end of the week, I cut this range and paste it in another sheet within the same file. The trick is that I have to paste it in the reverse order. So, cells from B--> H needs to be pasted in the reverse direction H-->B. How can I do this using VBA?

**realniceguy5000** · 06-28-2011, 05:25 PM

Hi, Welcome to the forum...

Here is one way with the help of a helper col. Note make sure you dont have data in col Z OR AA

Please Login or Register  to view this content.

**Paul** · 06-28-2011, 05:31 PM

Hi Gigz, welcome to the forum.

The following macro loops through rows on Sheet1 (from row 2 through your last used row) and for each row it loads an array, reverses the values and then pastes those values into Sheet2 starting in the next available row (starting in row 2 assuming a header row).

Please Login or Register  to view this content.

Hope that helps!

**gigz42** · 07-11-2011, 02:03 PM

Hi Paul and Mike. Thanks for your responses. I finally have a formula that works. The guy that created it for me said it is primitive, but hey, it works

Here it is:

Please Login or Register  to view this content.

**Paul** · 07-11-2011, 03:45 PM

Yes, that is quite primitive, but if it works it works.

Were the codes provided by Mike and I not working? We didn't hear back from you, so there was no way to tell.