On examining your file more closely, it looks as though you might be using Excel for Mac; can you confirm which version of Excel you're using?

I need to be able to run this report on my work computer, not Mac. We use Excel 2016.

Two things:
1. As I mentioned before: "If the source data changes, the table (a pivot table) will need refreshing (right-click it and choose Refresh).". This is not automatic (but it can be made to be).
2. If you're using Excel 2016 for Windows my attachment to post #3 should work.
Adding rows to the source data should be as easy as writing new entries immediately below the existing table, or pasting data to the same place. Just make sure the table extents cover your data (a small symbol in the bottom right corner of the bottom right cell of the table is apparent and you can click and drag it to cover your data, but this shouldn't be necessary since the table should adjust its size automatically.


I know nothing about the Mac versions of Excel but I suspect they don't have the Data Model. So I'll wait until you try it at work. Try the file I attached directly at work, don't use one you've first opened and saved on your Mac.

Hi, thank you for your help, I will try to open your spreadsheet on device with Windows PC just need to find one. My work computer will not connect to external sources due to server protection.
I tried to create new spreadsheet and create pivot table coping what you have done. Could you let me know how did you create Data label to include all dates and txt EID (fx)?

That would take me ages!
Perhaps download the file I attached in msg#3 to your computer at home but do not open it. Email yourself to your work email and attach that file. At work, open the file in Excel. Otherwise, copy the file to a memory stick and take it to work. There are no macros in the workbook.