Copy multiple worksheets data & paste into blank columns in summary worksheet

Hi

I have a workbook with several worksheets in excel 2010. I need to copy D2:D33 from each worksheet (with the exception of the Summary data) into the Summary worksheet. Column A in the summary tab are the data descriptions and row 1 is prefilled.

For example: Sheet 1 data in D2:D33 needs to paste into Summary column B2:B33, D2:D33 data in sheet 2 needs to paste into Summary column C2:C33, and so on.

This is what I've come up with so far, but it paste the data vertically in stand of horizontally. I think I may need a worksheet copy and paste loop, not sure :-/. I have been struggling trying to figure this out, please help!!!!

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Please Login or Register  to view this content.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Thanks for your help!!!!!!!

Thanks AB33,

I'll use code tags going forward.

I tried replacing the code I had with the one you provided once before, but for some reason it only copy/paste 1 of the many worksheets data rows D2:D33 instend of all of the worksheets. (I believe its copy/pasting only the worksheet furthest to the right.)

Any idea on how to solve this??

Thanks!!!

guest99999,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.