+ Reply to Thread
Results 1 to 10 of 10

VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

  1. #1
    Registered User
    Join Date
    02-10-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    Question VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    How to sync workbook1.sheet1 with workbook2.sheet1 with VBA. Please note that workbook2.sheet1 is same as workbook1.sheet1 but workbook1.sheet1 will be updated by user. The updated data in workboo1.sheet1 need to be synced up with workbook2.sheet1 for all columns that has data.

  2. #2
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Slough
    MS-Off Ver
    Excel 2007
    Posts
    469

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    Can't you just copy all the data across from sheet1 to sheet2?

  3. #3
    Registered User
    Join Date
    02-10-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    No DannyJ, actually few of the columns in workbook1.sheet1 has been updated that needs to be synced up with workbook2.sheet2. And I would required VBA to do that, rather than manual copy paste

  4. #4
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Slough
    MS-Off Ver
    Excel 2007
    Posts
    469

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    Please can you attach a desensitized copy of your workbook. Please include a desired outcome. I don't understand exactly what you need.

    To do this, click go advanced and then manage attachments.

  5. #5
    Registered User
    Join Date
    02-10-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    How to sync workbook1.sheet1 with workbook2.sheet1 with VBA. Please note that workbook2.sheet1 is same as workbook1.sheet1 but workbook1.sheet1 will be updated by user. The updated data in workboo1.sheet1 need to be synced up with workbook2.sheet1 for all columns that has data.

    Workbook1.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Swimming
    John Trecking
    Richard Music


    Workbook2.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Swimming
    John Trecking
    Richard Music


    But when Workbook1.sheet1 has been updated(only for James --> Swimming has been now updated with Jogging)
    Workbook1.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Jogging
    John Trecking
    Richard Music

    I will click a Sync button placed either on workbook1 or workboo2, that need to sync the data in workbook2.sheet1 from workbook1.sheet as below:

    Then workbook2.sheet1 need to get updated like as below
    Workbook1.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Jogging
    John Trecking
    Richard Music

  6. #6
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Slough
    MS-Off Ver
    Excel 2007
    Posts
    469

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    I still don't see why you can't just copy and paste the whole of sheet 1 to sheet 2?

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    02-10-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    How to sync workbook1.sheet1 with workbook2.sheet1 with VBA. Please note that workbook2.sheet1 is same as workbook1.sheet1 but workbook1.sheet1 will be updated by user. The updated data in workboo1.sheet1 need to be synced up with workbook2.sheet1 for all columns that has data.

    Workbook1.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Swimming
    John Trecking
    Richard Music


    Workbook2.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Swimming
    John Trecking
    Richard Music


    But when Workbook1.sheet1 has been updated(only for James --> Swimming has been now updated with Jogging)
    Workbook1.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Jogging
    John Trecking
    Richard Music

    I will click a Sync button placed either on workbook1 or workboo2, that need to sync the data in workbook2.sheet1 from workbook1.sheet as below:

    Then workbook2.sheet1 need to get updated like as below
    Workbook1.sheet1 has following data:

    Column A Column B
    Danny Cycling
    James Jogging
    John Trecking
    Richard Music

    I am having issues with the following scenarios:

    1. since its workbook1.sheet1 to workbook2.sheet1 sync up, please let me know how to do that
    2. Since there are only few updates being done on workbook1.sheet1 on daily basis by users, workbook2.sheet1 need to be updated in columns containing only those updated cells in workbook1.sheet1.

  8. #8
    Registered User
    Join Date
    02-10-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    Thanks for the code DannyJ, but i need to update Workbook2.sheet1 with workbook1.sheet1. It is two different workbooks. Thanks!

  9. #9
    Registered User
    Join Date
    02-22-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    17

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    try this short code
    Sheets("Sheet1").Select
    Range("A1:Z1000000").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("A1").Select
    ActiveSheet.Paste
    Last edited by jayvillalobos123; 02-28-2017 at 01:12 AM.

  10. #10
    Registered User
    Join Date
    02-10-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    Re: VBA to sync one workbook1.sheet1 with workbook2.sheet1 both have same contents

    Thanks for the code. Please let me know where to place this code, as I need to updated workbook2.sheet1 with workbook1.sheet1.

+ 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. Replies: 0
    Last Post: 02-14-2017, 11:55 PM
  2. =+Sheet1!A1+Sheet1!B1+Sheet1!C1 macro to convert all linked ref to Values
    By chriszoma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2013, 02:44 PM
  3. How to bring data from workbook1 to workbook2 by comparing values of workbook2
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2013, 09:38 AM
  4. merge book1,sheet1,book2,sheet1,book3,sheet1 ect
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2013, 01:30 PM
  5. How can I copy the data from workbook1(sheet1) to workbook2(sheet1)
    By wkshek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2010, 11:46 PM
  6. Data from workbook1 to workbook2 every week but in different place in workbook2
    By cheelie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2007, 06:26 PM
  7. Replies: 1
    Last Post: 05-18-2005, 09:06 AM

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