I've got some data from a survey. I'm trying to write some VBA that can take the master sheet and populate 3 new sheets from it (while duplicating the uniqueId field).
The number of rows will always be consistent 20 but the number of columns will change as more people respond. (The document will get a little wider)
Here is the sheet. The master tab is the source and the 3 additional tabs are the results I am trying to achieve through VBA.
Bookmarks