Pasting cells from one worksheet into another

Hi,
Can anyone help me? SEE ATTACHED SPREADSHEET FOR EXAMPLE OF PROBLEM.
I want to paste cells from one sheet into another but when I do I want to paste the cells into the "College" column (Far left column in the green TAB : Required Format) so that the data acts as if I have iinserted an equivalent number of rows. The data is sourced from from the blue TAB : Transposed Data. Currently I have to insert the equivalent blank rows first and then paste the data in from the other sheet (very laborious). ANy help would be greatly appreciated.
John Ivanac
Sydney Australia

Try this macro on your sheet as it exists now...

Please Login or Register  to view this content.

You can change the sheet names in red if needed.
=========
How to use the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select CollegeReport from the macro list.

Use this version:

Please Login or Register  to view this content.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)