Hello,
First of all I would like to thanks for allowing me to be part of this forum. I am currently maintaining a very complex excel workbook that has multiple worksheets for different LOB's within a company. The spreadsheet is used to report monthly performance numbers. Currently each representative of the LOB's are manually inputting the numbers resulting in deletion of links,formulas,lookups resulting in wrong calculations.
I would like to eliminate this issue by creating a separate infopath form for each LOB's to input data I intend to link each LOB form to their respective worksheet. Also my goal is to than create dashboards and KPI's and publish it on a sharepoint site.
My question is it possible for me to create forms in infopath that will automatically populate the various worksheets. Please any suggestions or advice is more than welcomed.
Thanks
Roger