| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert an Excel table to a list with VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a table into a list in excel? | Excel Worksheet Functions | |||
| Convert list to table | Excel Discussion (Misc queries) | |||
| How to convert a table to list? | Excel Worksheet Functions | |||
| How to convert existing Excel List into a table in Access? | New Users to Excel | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
