Home

Count dates in multiple worksheets and display in a summary sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-450346%22%20slang%3D%22en-US%22%3ECount%20dates%20in%20multiple%20worksheets%20and%20display%20in%20a%20summary%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-450346%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20customer%20data%20base%20that%20I%20have%20each%20customer%20on%20a%20seperate%20worksheet%20so%20that%20I%20make%20notes.%26nbsp%3B%20I%20want%20to%20put%20in%20the%20dates%20that%20I%20followed%20up%20with%20each%20client%20in%20their%20respective%20sheet%20and%20then%20have%20the%20total%20customers%20contacted%20on%20any%20one%20date%20be%20displayed%20in%20a%20summary%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-450346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECounting%20Dates%20on%20Multiple%20Worksheets%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452503%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20dates%20in%20multiple%20worksheets%20and%20display%20in%20a%20summary%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452503%22%20slang%3D%22en-US%22%3EExcel%20is%20NOT%20a%20database%20and%20your%20setup%20does%20not%20make%20this%20easier%20to%20do.%20You%20might%20improve%20things%20by%20stuffing%20it%20all%20in%20one%20large%20table.%20That%20way%20you%20can%20simply%20filter%20by%20customer%20to%20see%20how%20many%20contact%20moments%20you%20had.%20I'm%20sure%20if%20you%20search%20for%20CRM%20software%20you%20should%20be%20able%20to%20find%20affordable%20solutions%20that%20handle%20this%20way%20better%20than%20anything%20you%20can%20build%20in%20Excel.%3C%2FLINGO-BODY%3E
sbeardsley51
New Contributor

I am creating a customer data base that I have each customer on a seperate worksheet so that I make notes.  I want to put in the dates that I followed up with each client in their respective sheet and then have the total customers contacted on any one date be displayed in a summary worksheet.

1 Reply
Highlighted
Excel is NOT a database and your setup does not make this easier to do. You might improve things by stuffing it all in one large table. That way you can simply filter by customer to see how many contact moments you had. I'm sure if you search for CRM software you should be able to find affordable solutions that handle this way better than anything you can build in Excel.
Related Conversations