• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code to change a list with data in rows to a new list with data in columns

shiva

New Member
Hi

Seeking help on a list. The data is a monthly score for some suppliers. Each new month a column is created and the data is stored in that column.

Want to change that list such that month and year should be in 2 columns and the corresponding scores in another column.

The entire exercise so as to limit the horizontal growth of the list with each passing month.

Can we have a vba code to copy data from the original list to this new list?

Thanking in anticipation

Shiva
 

Attachments

  • Book2.xlsx
    12 KB · Views: 0
I did it without VBA just using formula
upload_2015-5-25_23-23-54.png

You can add Monthly data
And even insert extra rows, between Supplier A & D, not after D

See attached:
 

Attachments

  • Book2-1.xlsx
    11.1 KB · Views: 0
Thanks Hui,

I have an additional task on this please.

So now 16 records i.e. 4 results for 4 months but if i add an additional month the result rows will be 20.

Can we automate like formula in 100 rows and to fill data in relevant rows and remaining be blank i.e. if we add may then 100-20 = 80 rows will be ""

thanks in advance
 
Back
Top