Originally Posted by
June7
The output on the Excel sheet is not a normalized structure. If you don't want to retain data in normalized relational database structure and all you want Access for is a 'friendly' user interface for data entry and pass the data onto spreadsheet - fine, it is possible. It is also possible to build form objects in Excel that could act as a 'friendly' user interface for entry onto sheet. It is probably complicated code but pushing the data from Access onto Excel sheet is also complicated. Any time two applications must be made to interact, just compounds the difficulties even more.
This process starts complicated because you want to add data to existing sheet without destroying data already on it. Then in addition want to pass the data from Access to Excel, not simple. The more friendly, the more code.
I can't just pull code out of the air for this situation. I don't do much coding in Excel - this is an Access forum after all - and not much that involves interaction between Excel and Access - although it is a fairly common topic here and I have contributed to discussions - look at some if you haven't yet seen code involved in Access/Excel interoperations.
What I am getting at is this project would be a significant dedication of time and I am not interest in tackling it. I am willing to review code you develop and encounter specific issues with. So unless someone else steps up to take this on, you need to learn the programming this would require and build it or find a professional programmer to build for you.
As I said, possible but is it worth the time and effort?