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
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies