+ Reply to Thread
Results 1 to 2 of 2

Excel Master file (workbook ) row updates automatically as othe workbook is updated

  1. 07-19-2013, 02:24 PM #1
    sunnytaru
    sunnytaru is offline
    Registered User
    Join Date
    07-19-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Arrow Excel Master file (workbook ) row updates automatically as othe workbook is updated

    I need help with

    I have a master file which has project numbers for individual PMs.
    I have 8 other workbooks for individual PMs same format as master.

    Using Vlookup I can update some columns in master. Instead of using Vlookup for every column Is there a way to update master when anything changes in the PMs file.
    I tried Link but if PMs inset a row my links will get messed up.

    Kindly Help

    TM
    Reply With QuoteRegister To Reply
  2. 07-19-2013, 04:34 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel Master file (workbook ) row updates automatically as othe workbook is updated

    Hi sunnytaru,

    You could use the Workbook Sheet Change Event in each of the subsidiaries.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I would like to append and update excel master workbook with new and updated rows.
    By uvwaves in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2013, 03:14 PM
  2. Copy onto new row into another workbook each time master workbook is updated
    By Ali.B in forum Excel General
    Replies: 3
    Last Post: 05-17-2012, 11:25 AM
  3. [SOLVED] How to create a duplicate 'read only' workbook that auto updates from a master workbook
    By lduke in forum Excel General
    Replies: 3
    Last Post: 04-11-2012, 09:07 PM
  4. automatically create a workbook from Master workbook
    By dougie1758 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2010, 02:25 AM
  5. [SOLVED] How do I automatically send daily email of updated Excel workbook.
    By How to automate emails with excel file. in forum Excel General
    Replies: 1
    Last Post: 05-09-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1