Access-type projects in Excel

[Guest]

Greetings;

The company computers are CHEAP. They do not have Access on them, and they want a system set up that simply a daily summary sheet is filled in and automatically allocated to different worksheets - with weekly and monthly summary reports generated.

Doing this in Access is not a huge issue, I know (even though I am programming-retarded). I was wondering if all or part of this was possible to do in Excel?

THANKS FOR RESPONSES!!

 

[BrianB]

In the absence of another reply. I would start with a simple table wit
headings in row 1 and add all data (including columns to help analysi
such as Date and Week Number) to this in rows undeneath.

You can use the Menu Data/Form to help with data input. Any analyse
can be done easily with pivot tables