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
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