Hello!
Thanks in advance for your help.
I have a flattened PivotTable on a worksheet that is automatically pulling data from an SQL reporting server updating once an hour. On the worksheet, I have data adjacent to each row of the PivotTable (on the left) that I am adding manually that I want to keep linked to the other data in that row from the PivotTable. My problem arises when new data is added automatically to the PivotTable as a new row. When it is sorted automatically after every sync, this pushes other rows in the PivotTable down but without the adjacent offline data moving down it. Can the offline adjacent data be inherently linked to PivotTable data in the same row?
In the attached image, my manually added data is everything left of 'Registered Date' and everything to the right of 'Registered Date' is data in the flattened PivotTable pulled from the SQL server.
Hopefully this makes sense, but let me know if I can elaborate further or provide any more images!
Thanks,
Hal
Bookmarks