Novicesportsperformer
New Member
- Joined
- Nov 21, 2016
- Messages
- 37
Hi Everyone, I'm looking for you expertise here!
I have never had to do this before so I am very confused with it all.
I am trying to put about 400 different workbooks (all headings and rows) into one worksheet table.
I need the formation to go from being in vertical in the workbooks to horizontal in the new worksheet table as well.
I then want to be able to create a graph off of all this information via a pivot table with splicers.
Would anyone know how to help me on this?
kindest regards!
I have never had to do this before so I am very confused with it all.
I am trying to put about 400 different workbooks (all headings and rows) into one worksheet table.
I need the formation to go from being in vertical in the workbooks to horizontal in the new worksheet table as well.
I then want to be able to create a graph off of all this information via a pivot table with splicers.
Would anyone know how to help me on this?
kindest regards!
