Results 1 to 25 of 25

Auto Update Rows in One Sheet from Another

Threaded View

  1. #6
    Registered User
    Join Date
    06-28-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Auto Update Rows in One Sheet from Another

    This was a great first go at it! The issue update looks to be running great, but there were a few issues with the risks update ... See below:

    1) I forgot to add the Status column to the risk tracker sheet. If that could be added to the criteria that would be great.
    2) If you run the macro multiple times the updates to risk tracker on the status page will continuously add empty rows. After about the fifth run of the macro it acts funky and begins to insert rows formatted like the header. If you hit the macro enabled button 5 times you will see what I mean.

    I've attached a copy of the workbook with the macro created for your reference. Thank you so much for you help on this. It's so close!

    TJH
    Attached Files Attached Files
    Last edited by tjhart; 07-13-2012 at 02:51 PM.

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