I create a Survey report every day
Question I have a datasheet with 25 question each answer is given 1 out of 5
(Strongly Agree, Agree, Neither Agree or disagree, Disagree and Strongly disagree)
I would like a macro to create 25 Pivot tables with the results on a single worksheet
Is this possible???
The short and snarky answer is, Yes it is possible.
To improve your chances of getting a response include a sample workbook. See the yellow banner at the top of the sheet.
While there are a few questions that can be answered without a sample workbook, most of them go a LOT better when a sample workbook is included.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks