Forum Discussion

Beverley2185's avatar
Beverley2185
Copper Contributor
Feb 25, 2024

Create worksheet

Hi I wonder is someone can help me I starting dog grooming and need toncreate a daily worksheet for every day included in that sheet I need to enter lots of info then I would like to create monthly worksheet with all dogs booked and if I click on that months worksheet I want to see separate weekly and daily work sheet I have no clue about speed sheet

Excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Feb 25, 2024

    Beverley2185 

    You may keep all your records in one sheet and based on it create PivotTable which shows you monthly, weekly, etc summary. Of filtered table(s) if you are not going to aggregate any data.

      • Beverley2185's avatar
        Beverley2185
        Copper Contributor
        Feb 25, 2024
        Can I please do example just so you know what I mean
        Monday 26th Feb
        Time..... dog name and breed....style...cost....comb att....paws...teeth... ect
        All that on one line .so I need
        7am
        8am
        9am
        Ect
        So I need this daily and also weekly and monthly veiw