I have an Access DB with various forms and reports.
Surprisingly for 2 of the forms, the users would like the ability to view the data in Excel so that they can play around with the values !
I cannot export it directly from Access because of the way the forms are laid out (various calculated control boxes, calculations in the footer, etc.).

So, I thought it wud be an idea to retrieve all the relevant data directly from Excel (linked to the Accss DB). The problem I have is that depending on the data, the row marked TOTALS in the Excel database will need to be in a different position each time. I may also need to run 1 query for a range of cells and a separate query for another.

Can this be done in Excel so that I could lay out the spreadsheet in the same format as the Access form ? If so, how would I start with repositioning the TOTALS row depending on where the data had ended?