Hi there.
I currently have 2 sheets in my workbook, the first contains data which is populated by a SQL source which is manually refreshed. Once the data is refreshed it gets pasted to the other sheet where users then write comments next to the entries.
The source data is sorted by week and the most recent is at the top.
I use an advanced filter (Excel 2007) to show just data relating to the current week which is working OK so far. The problem arises where I want to then shift all of the comments down so that they match the correct rows.
In my example the data in "working sheet e5:f7" was originally listed against data from week 46 until I updated it.
Could I apply some sort of count to see how many new rows have been added (filtered) and then shift the info in e6:f7 down by that amount?
Thanks in advance.
Bookmarks