<div>
thanks a bunch - this is working very well for me. &nbsp;I wound up using the SharePoint Survey as my company does not have the excel survey installed for OneDrive... I then set up a VBA in my excel book to refresh every 30 seconds so my dashboard is pretty much real time.
</div>


<div>
<div class="content wysiwyg-content">
hi Experts, i'm trying to pull together an excel based solution (though I'm open to other software) that will help me gather information at a polling booth for an upcoming event.<br />
<br />
We will have 4 to 6 laptops set up on which I'd like to have a spreadsheet, or an infoPath form, open to collect customer feedback - it will be a mix of multiple choice questions, ranking of options, and open feedback. &nbsp;I'd like the user to complete the form and click a &quot;submit&quot; button. &nbsp;That button would send the data to a central spreadsheet stored on SharePoint (or a SharePoint List) which would then update some charts in real-time. &nbsp;The charts will be displayed on a screen behind the booth so that the customers can instantly see impact of their feedback.<br />
<br />
I'm suggesting Excel because I'm comfortable with VBA and SharePoint, but as I mentioned, if there is something else out there - more than happy to entertain better suggestions.
</div>
</div>


hi Experts, i'm trying to pull together an excel based solution (though I'm open to other software) that will help me gather information at a polling booth for an upcoming event.

We will have 4 to 6 laptops set up on which I'd like to have a spreadsheet, or an infoPath form, open to collect customer feedback - it will be a mix of multiple choice questions, ranking of options, and open feedback.  I'd like the user to complete the form and click a "submit" button.  That button would send the data to a central spreadsheet stored on SharePoint (or a SharePoint List) which would then update some charts in real-time.  The charts will be displayed on a screen behind the booth so that the customers can instantly see impact of their feedback.

I'm suggesting Excel because I'm comfortable with VBA and SharePoint, but as I mentioned, if there is something else out there - more than happy to entertain better suggestions.

thanks a bunch - this is working very well for me.  I wound up using the SharePoint Survey as my company does not have the excel survey installed for OneDrive... I then set up a VBA in my excel book to refresh every 30 seconds so my dashboard is pretty much real time.

Excel Based Polling Solution

hi Experts, i&amp;#39;m trying to pull together an excel based solution (though I&amp;#39;m open to other software) that will help me gather information at a polling booth for an upcoming event.

We will have 4 to 6 laptops set up on which I&amp;#39;d like to have a spreadsheet, or an infoPath form, open to collect customer feedback - it will be a mix of multiple choice questions, ranking of options, and open feedback.  I&amp;#39;d like the user to complete the form and click a &amp;quot;submit&amp;quot; button.  That button would send the data to a central spreadsheet stored on SharePoint (or a SharePoint List) which would then update some charts in real-time.  The charts will be displayed on a screen behind the booth so that the customers can instantly see impact of their feedback.

I&amp;#39;m suggesting Excel because I&amp;#39;m comfortable with VBA and SharePoint, but as I mentioned, if there is something else out there - more than happy to entertain better suggestions.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.