We have been collecting customer surveys for some time and decided to revise both the survey and the target spreadsheet.
Basically, we cloned the original survey (#1), removing a question no longer needed.
We created a new Excel connection to the clone (Survey #2) and got clean data in Spreadsheet#2. We added a number of pivot tables to this sheet, and everything looks good.
Now, we want to re-create this arrangement for another employee. Rather than recreate all these pivot tables, can we CLONE Survey #2 and Spreadsheet#2?
In other words, can we connect a new survey to an existing spreadsheet?
Note: we don’t have to import existing data. Nice to have, but not critical.
Best answer by john.desborough
View original