I want to convert a table to a list
I am still struggling with VBA.
I have not been able to find a similar example.
Can anyone help ?
Thank you.
Wayne.
Input table - WorkSheet A
-------------------------
Week1 Week2 Week3 week4
Activity 1 1
Activity 2 2 3
Activity 3 2 5 4
Wanted output list on WorkSheet B
Desc Activity Qty
-----------------------------------
Week 1 Activity 1 1
Week 1 Activity 3 2
Week 2 Activity 2 2
Week 3 Activity 3 5
Week 4 Activity 2 3
Week 4 Activity 3 4
Bookmarks