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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies