Hello. I am new to InfoPath so I dont know if this is even possible:
I would like to see if there is a way to export information entered into an InfoPath form to an Excel sheet. The desired result would be to add an export button to the InfoPath form. The button would link to an event that would copy the data and save to an existing Excel workbook as a new sheet. I am comfortable using VBE if needed, but an not very experienced (I use lots of references). Both the Excel workbook and the InfoPath form are on a Sharepoint site. Another ideal feature would be the ability to map certain a form entry to a specific cell in the Excel sheet.
If this is beyond the core MS functions I can also break out the VB, but am trying to avoid this if possible.