Results 1 to 14 of 14

VBA / Macro help needed to auto update the data from another workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question VBA / Macro help needed to auto update the data from another workbook

    Hi Folks,

    I have two workbooks first one is called "JobList.xlsm" and second one is "Workpack_Status_Tracker.xlsm". And, these are handling by two separate users.

    I need a Macro to update some columns from "JobList.xlsm" to "Workpack_Status_Tracker.xlsm" and one column from "Workpack_Status_Tracker.xlsm" to "JobList.xlsm", if any changes made in the workbooks. Also I have a "Summary" sheet in "Workpack_Status_Tracker.xlsm" these also need to updated (details marked in the sheet).

    I have attached an excel file of what I'm trying to accomplish. Thanks in advance for your expertise!

    Joshi
    Attached Files Attached Files
    Cheers,

    Joshi
    Being with a winner makes you a winner

Thread Information

Users Browsing this Thread

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

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