Hello
I'm not sure if this is the right place. I haven't used excel much since my school days, but would like to set up a simple database in Excel that I can use to keep track of jobs. And from this database I would like to be able to print out basic worksheets and quotes. I'd also possibly like to organise jobs in a calendar style layout too, but I'm not sure if this is possible.
In my ideal world I'd enter the data, be able to view either as a table and as a calendar, with items in the calendar linked back to the table where I can print my reports.
I have worked out how to create a form and enter the data through that. But beyond my initial table I'm not too sure what to do next... Create a pivot table...
Any advice is much appreciated, I can comfortably follow tutorials etc, I just need help in the direction of planning and how to put it all together (what functions etc to use).
Thank you kindly
I'm not sure if this is the right place. I haven't used excel much since my school days, but would like to set up a simple database in Excel that I can use to keep track of jobs. And from this database I would like to be able to print out basic worksheets and quotes. I'd also possibly like to organise jobs in a calendar style layout too, but I'm not sure if this is possible.
In my ideal world I'd enter the data, be able to view either as a table and as a calendar, with items in the calendar linked back to the table where I can print my reports.
I have worked out how to create a form and enter the data through that. But beyond my initial table I'm not too sure what to do next... Create a pivot table...
Any advice is much appreciated, I can comfortably follow tutorials etc, I just need help in the direction of planning and how to put it all together (what functions etc to use).
Thank you kindly
