How to auto populate another sheet from an existing sheet.

[pjdube]

Dear All,

Hi! I have a Master Sheet which records daily entries of calls, contacts, appointments etc, of around four staff.
For instance:
Calls Cont App Int
...
Wed, 6-Mar-19 0 0 0 2
Thu, 7-Mar-19 9 3 1 0
Fri, 8-Mar-19 6 3 0 1
Mon, 11-Mar-19 10 2 0 1
Tue, 12-Mar-19 12 5 0 2
Wed, 13-Mar-19 18 5 0 2
Thu, 14-Mar-19 0 0 0 4
Fri, 15-Mar-19 0 0 0 4
Mon, 18-Mar-19 1 1 1 1


I am trying to make another sheet grab the entire weeks worth of data (Thursday, Friday, Monday, Tuesday and Wednesday).
For Instance:
Calls Cont App Int
7-Mar-19 32 9 0 8
13-Mar-19 37 13 1 4
21-Mar-19 19 6 1 11


I figured out how to do this manually by each week having to manually drag down the formula. Is there a way to program it so that it automatically does it? It would save so much time and make it more user friendly.

See attached excel sheet.

Phil

 

[James006]

Hello,

Best available solution ... is to insert a Pivot Table ...

Once your Pivot table is designed, you can use ' Grouping Dates '

https://www.contextures.com/xlPivot07.html

Hope this will help