I have an Excel workbook that imports data from an Access database to a specific worksheet. On another worksheet (or 4) I have a number of tables summarising the company data using quite complicated formulae.
My customer would now like that summary analysis to also be available from within the Access database front end. In order to avoid the need to maintain two independent methods of performing the same analysis, I would like to simply embed the summary analysis worksheet in an Access form.
Please can you tell me if this is possible?