You are reading a single comment by @NotThamesWater and its replies.
Click here to read the full conversation.
-
Data is entered via SelectSurvey.net.
Data comes out as SPSS condensed, csv format.Data gets saved to xlsx format. Macro runs through and cleans, adds columns etc.
Data then gets transferred to a dashboard sheet.Prizes awarded for :
Can you connect directly to select survey
Can you use BI
Have you thought about x y z
Chalfie
@NotThamesWater
Can you protect the input spreadsheet and lock the cells to numeric (with data validation)?