+ Reply to Thread
Results 1 to 6 of 6

multiple sheets that dynamically update

  1. #1
    Registered User
    Join Date
    05-27-2008
    Posts
    4

    multiple sheets that dynamically update

    Hello,

    Is there a way to create a second worksheet that is based on data from an original sheet that will automatically update when you ADD ROWS to the original sheet?

    Linking values between sheets is easy... but I need to be able to set a designated area on my A sheet that I can add rows into which will automatically be added to my B sheet.

    Does anyone know of a function that I can apply for this?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    Welcome to the forum.

    Can I first ask why you want to create what appears to be somewhat of a duplication of records? What's the final outcome you're trying to achieve? Sometimes knowing the end point helps in determining the process to get there rather than starting with something and inventing incremental steps which may not be as efficient.


    That said, the shirt answer is yes, it would be fairly simple with a VBA macro to arrange to update the B sheet with new records from sheet A, either directly from within the data, or from a dedicated 'new rows' area.

    Regards

  3. #3
    Registered User
    Join Date
    05-27-2008
    Posts
    4
    Thanks for your reply.

    Here's my desired outcome:
    I have a set of information in sheet A that is updated occasionally. One of the columns in A contains information pertaining to each record that is something like: New, Omit, Priority, etc.
    At any given moment, I want to be able to quickly create a new sheet that will automatically sort all of the items from one of those categories. IE: a sheet with all of the "New" records, a sheet with all of the "Priority" records, etc. I know about using vlookup to do this manually, but I thought if there was a sheet that contained a clone of all of the data, I could easily filter if I needed to. If there is another way to achieve my outcome, I am open to suggestions.

    Thanks for the help!

  4. #4
    Registered User
    Join Date
    05-27-2008
    Posts
    4
    Any ideas?

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    Is there any reason why a bog standard Data Autofilter/Sort won't give you the filtered results you need without needing to involve a second sheet?

    If you really do need a new sheet containing a subset of the main sheet then a VBA solution would need to do a filter as part of the process of updating a second sheet anyway. If that's what you really want then it's not a problem. The only other question I'd ask is would you want the second sheet clearing each time to receive new data, or would you want to retain the data and add a 3rd, 4th....etc sheet as time goes by?

    Rgds

  6. #6
    Registered User
    Join Date
    05-27-2008
    Posts
    4
    The reason why I'm filtering the items is so that I can make a report on them. I want to be able to have a sheet set up with my report info on the bottom, and the data that i want to filter in the body, so that I can easily sort the data and make a pdf of the sheet for my report.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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