Hi All!
I have two worksheets linked to a SharePoint database with several columns of dates corresponding to different IDs. I want to pool all of those dates together so that I can see what IDs (with accompanying descriptions) are coming up this upcoming week, month, etc.
date table tests.JPG
Right now, I run a macro to do this manually. However, every time I refresh my linked data, I have delete my old table to run the macro again.
Is there an easier way consolidate all this data together through a single pivot table, and have each column header and table called out? It would look similar to my manual macro generated table, but would be able to update dynamically. I have Excel 2016.
Thanks!
Bookmarks