Results 1 to 4 of 4

Shift range down by x amount of rows

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Shift range down by x amount of rows

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1