Results 1 to 8 of 8

Macro for Updating workbook with button from another workbook

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Macro for Updating workbook with button from another workbook

    Greetings;

    I have several workbooks that have a value each in Sheet1 Cell A1
    I also have a workbook called Master-1.xlsm where on sheet Data List I like to have the values from the other workbooks with the button in these books.
    I am able to update from Sheets within Master-1.xlsm using buttons however I am lost doing this from other workbooks. (both books are opened).

    This is the code in the workbook that with a button is to update Master-1.xlsm Sheet Data List in column A .....this does not work.

    
    Sub Sheet1_Button1_Click()
     r = 1
         Sheets("Sheet1").Range("A1").Copy
        If Sheets("Sheet1").Range("A10") = "Master-1.xlsm" goto Sheets "Data list".Range("A65536").End(xlUp) _
            Then r = 0
         Sheets("Data List").Range("A65536").End(xlUp).Offset(r, 0).PasteSpecial _
            Paste:=xlPasteValues
        Application.CutCopyMode = False
    End Sub
    Please advice and thanking You in advance.....Cl.Klink
    Last edited by Cl.Klink; 04-25-2014 at 12:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] updating a parent workbook from a child workbook via Userform
    By smooth_beaker in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-01-2013, 08:39 AM
  2. [SOLVED] Updating the asset amount column in a workbook from another workbook
    By nirmalreigns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2012, 11:56 AM
  3. Opening & updating another workbook from an open workbook using a macro.
    By FV99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2012, 06:34 AM
  4. Replies: 0
    Last Post: 07-27-2011, 09:48 PM
  5. updating the master workbook whenever user click submit in check workbook
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2011, 10:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1