|
|
#5
07-31-2024, 07:05 AM
|
||||
|
||||
I can do something like this which shows all the time where data has come from:
At the moment it doesn't show names or weekdays which have no data. 2024-07-31_150505.jpg and if you double-click on a cell with hours in you get a separate sheet with the likes of: 2024-07-31_150643.jpg It's based on a pivot table which is in turn based on consolidated data from your job# sheets. Any use? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Excel to Audit Data Responses (IF and THEN identify wrong answers) | tdeogburn | Excel Programming | 0 | 01-25-2022 04:33 AM |
| VBA Word : identify empty cell and aply specific format | Denalei | Word VBA | 2 | 01-05-2022 12:41 AM |
| How to restore collected addresses | Atom | Outlook | 0 | 10-22-2021 11:56 AM |
| How to identify Overlap Dates data | golden618 | Excel Programming | 0 | 10-28-2015 04:34 AM |
| Identify last blank cell in column | mbesspiata | Excel | 0 | 02-27-2015 11:29 AM |
Windows 10 
Office 2021
Threaded Mode