Results 1 to 4 of 4

Update MasterWorkBook when I click a Cmdbutton/macro

Threaded View

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

    Lightbulb Update MasterWorkBook when I click a Cmdbutton/macro

    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

    ==========
    MODERATOR's NOTE:
    This question has been crossposted here.
    Attached Files Attached Files
    Last edited by MarcGo; 06-30-2015 at 10:13 AM. Reason: Crosspost link added as per forum rules. Please read and follow all the forum rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. Double Click Macro to update another Workbook
    By Cl.Klink in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2014, 08:39 PM
  3. [SOLVED] Repeatedly click a cmdButton to populate a TextBox with different cell values
    By LordBucketHead in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2013, 03:22 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. macro help: click button to update value of primary cell
    By uthminister in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2009, 10:46 AM

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