Looking for samples of Client List Database where Dates and/or Number of Visits can be tracked

[Dawn_G]

Hello all. I'm a basic Excel user trying to create a spreadsheet for a friend - also a basic Excel user - who owns a dog grooming business. It will be your standard client list, with a few special columns like:

• Special Needs (like muzzle - will bite, or soothing oatmeal shampoo for skin, etc.).
• Time Needed (some dogs have long hair vs. short, but also scared dogs also need more time to do things slowly so they're not stressed; the time won't be tracked, it will just help her understand how long that dog needs when an appointment is requested -- usually by phone call or text)
• Products Used (I'm hoping this will eventually help her track her supply needs)

What I'd also like to do is help her track the dates of the visits, so she can reward her "frequent flyers" and/or help her follow up on someone who hasn't come in for some time. Below is a basic example of what I'm thinking.

Is there a better way to track these visits other than 25-100 columns called DATE for each customer row?

Could I create ONE column called VISITS and put in a link to take me to another worksheet within the workbook where these dates could be registered? If so, how so I link those visits up with the correct client?

Any an all ideas are welcome! Thanks.

[TABLE="class: grid, width: 50, align: left"]
<tbody>[TR]
[TD]ClientID[/TD]
[TD]FirstName[/TD]
[TD]LastName[/TD]
[TD]DogName[/TD]
[TD]Breed[/TD]
[TD]SpecNeeds[/TD]
[TD]Time[/TD]
[TD]Products[/TD]
[TD]Street[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[TD]Cell#[/TD]
[TD]Other#[/TD]
[TD]Date[/TD]
[TD]Date[/TD]
[TD]Date[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Susan[/TD]
[TD]Brown[/TD]
[TD]Skippy[/TD]
[TD]Shih Tzu[/TD]
[TD]None[/TD]
[TD]1 Hr[/TD]
[TD]Silk Conditioner[/TD]
[TD]123 Main[/TD]
[TD]Anywhere[/TD]
[TD]KY[/TD]
[TD]40000[/TD]
[TD]123-456-7893[/TD]
[TD][/TD]
[TD]8/6/19[/TD]
[TD]10/6/19[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]White[/TD]
[TD]Rascal[/TD]
[TD]Jack Russel[/TD]
[TD]Muzzle[/TD]
[TD]45 Min[/TD]
[TD]Oatmeal Shampoo[/TD]
[TD]484 First[/TD]
[TD]Anywhere[/TD]
[TD]KY[/TD]
[TD]40000[/TD]
[TD]123-987-7515[/TD]
[TD]123-987-8644[/TD]
[TD]6/5/19[/TD]
[TD]9/5/19[/TD]
[TD]12/10/19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Chris[/TD]
[TD]Black[/TD]
[TD]Killer[/TD]
[TD]Yorkie[/TD]
[TD]Scared easily[/TD]
[TD]1 Hr 30 Min[/TD]
[TD]Silk Conditioner[/TD]
[TD]632 Sixth[/TD]
[TD]Anywhere[/TD]
[TD]KY[/TD]
[TD]40000[/TD]
[TD]123-258-9713[/TD]
[TD][/TD]
[TD]7/7/19[/TD]
[TD]8/22/19[/TD]
[TD]10/10/19[/TD]
[TD]11/24/19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Cooki]

Hi Dawn

As you have already said you could have another sheet where you record each visit on, your visit sheet, then have a front page to auto track how many visit that person has had.

A simple count of the client ID from the visit sheet to your front page would work.

The unique ID for the customer is the number that would never change for that customer, so counting that ID would give you the answer you wanted

Store the information of the visits on another sheet and then on your front page create column called what ever you wanted Number of Visits

Type: =COUNTIF(Visits!B:B,Sheet1!B3)

then drag it down and you will get a count of number of visits

[TABLE="width: 339"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Visit Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Susan[/TD]
[TD]Brown[/TD]
[TD]Skippy[/TD]
[TD="align: right"]12/12/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]White[/TD]
[TD]Rascal[/TD]
[TD="align: right"]01/11/2019[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Chris[/TD]
[TD]Black[/TD]
[TD]Killer[/TD]
[TD="align: right"]01/01/2019[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Susan[/TD]
[TD]Brown[/TD]
[TD]Skippy[/TD]
[TD="align: right"]02/10/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]White[/TD]
[TD]Rascal[/TD]
[TD="align: right"]02/02/2019[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Chris[/TD]
[TD]Black[/TD]
[TD]Killer[/TD]
[TD="align: right"]02/02/2018[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Susan[/TD]
[TD]Brown[/TD]
[TD]Skippy[/TD]
[TD="align: right"]01/01/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]White[/TD]
[TD]Rascal[/TD]
[TD="align: right"]02/02/2019[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Chris[/TD]
[TD]Black[/TD]
[TD]Killer[/TD]
[TD="align: right"]01/07/2019[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 979"]
<colgroup><col span="14"><col></colgroup><tbody>[TR]
[TD]lientID[/TD]
[TD]FirstName[/TD]
[TD]LastName[/TD]
[TD]DogName[/TD]
[TD]Breed[/TD]
[TD]SpecNeeds[/TD]
[TD]Time[/TD]
[TD]Products[/TD]
[TD]Street[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[TD]Cell#[/TD]
[TD]Other#[/TD]
[TD] Visits[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Susan[/TD]
[TD]Brown[/TD]
[TD]Skippy[/TD]
[TD]Shih Tzu[/TD]
[TD]None[/TD]
[TD]1 Hr[/TD]
[TD]Silk Conditioner[/TD]
[TD]123 Main[/TD]
[TD]Anywhere[/TD]
[TD]KY[/TD]
[TD="align: right"]40000[/TD]
[TD]123-456-7893[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Joe[/TD]
[TD]White[/TD]
[TD]Rascal[/TD]
[TD]Jack Russel[/TD]
[TD]Muzzle[/TD]
[TD]45 Min[/TD]
[TD]Oatmeal Shampoo[/TD]
[TD]484 First[/TD]
[TD]Anywhere[/TD]
[TD]KY[/TD]
[TD="align: right"]40000[/TD]
[TD]123-987-7515[/TD]
[TD]123-987-8644[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Chris[/TD]
[TD]Black[/TD]
[TD]Killer[/TD]
[TD]Yorkie[/TD]
[TD]Scared easily[/TD]
[TD]1 Hr 30 Min[/TD]
[TD]Silk Conditioner[/TD]
[TD]632 Sixth[/TD]
[TD]Anywhere[/TD]
[TD]KY[/TD]
[TD="align: right"]40000[/TD]
[TD]123-258-9713[/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]


Hope this is what you was after

 

[Dawn_G]

That looks like a great idea! Thank you. I'll give it a try.