Hello everyone,
I have attached a mock workbook to try and show what I need done and here is the explanation:
When the "AM Data" sheet updates from it's source (Sharepoint) I need the entries on the "tracking" sheet to insert a new row for the new data and move everything else down by the number of new entries from "AM data". This applies to all columns A to K.
So if there is one new entry in the "AM Data", then I need the entry 4229 (A6 - K6) to move everything down one row so that all the previous entries stay lined up with the right data. Same if there is two new "AM Data" entries, or three or four, etc. ... I need the "Tracking" sheet to move everything down the right number of rows to make room for the new data.
Currently when I get new data, the "B Column" updates it properly and pushes everything down, but the other columns do not get new rows and then the related data isn't in-line with it's respective non-pivot data.
I hope that makes sense.
Thanks in advance for any help!
Bookmarks