+ Reply to Thread
Results 1 to 2 of 2

BabyWorkBook - - - - - - > MasterWorkbook Update Automatically

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    Philippines
    MS-Off Ver
    excel 2007
    Posts
    4

    Lightbulb BabyWorkBook - - - - - - > MasterWorkbook Update Automatically

    Hello so here is problem

    I have a masterworkbook(marcgoproject4.xlsm) it has five(5) sheets all has headers
    sheets name :
    sheet1=ADDITEM
    sheet2=ITEMLIST
    sheet3=RECEIVED
    sheet4=SHIPPED
    sheet5=STOCK

    now the problem is i also have a babyworkbook(in.xlsx) that gets updated regularly only has one(1), sheet1 it also has a header

    so the problem is i want to automatically update the master workbook sheet3("received") when ever i update or do something with my babyworkbook.

    or for example i changed something in my babyworkbook then saved it. then when i open my masterworkbook i have a button that i can click so my (received)sheet will be updated.



    PLEASE HELP.
    BEST REGARDS (Y)

    -MarcGo
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: BabyWorkBook - - - - - - > MasterWorkbook Update Automatically

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-prog...ton-macro.html

    Thread Closed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Update MasterWorkBook when I click a Cmdbutton/macro
    By MarcGo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2015, 06:23 PM
  2. Automatically Update my masterworkbook when i add stuff to my babyworkbook
    By MarcGo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2015, 04:21 AM
  3. Copy Columns from Workbook to MasterWorkbook
    By timdecker in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-21-2014, 03:08 PM
  4. [SOLVED] copy rows from 42 workbooks into masterworkbook
    By kandre in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-04-2012, 10:08 AM
  5. Automatically update existing data using a Update command button
    By 9999335 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 09:46 PM

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