Results 1 to 14 of 14

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

Threaded View

krjoshi VBA / Macro help needed to... 05-17-2013, 04:04 AM
arlu1201 Re: VBA / Macro help needed... 05-18-2013, 10:45 AM
krjoshi Re: VBA / Macro help needed... 05-18-2013, 10:51 AM
arlu1201 Re: VBA / Macro help needed... 05-18-2013, 10:55 AM
krjoshi Re: VBA / Macro help needed... 05-18-2013, 10:58 AM
arlu1201 Re: VBA / Macro help needed... 05-20-2013, 07:08 AM
krjoshi Re: VBA / Macro help needed... 05-20-2013, 09:34 AM
arlu1201 Re: VBA / Macro help needed... 05-20-2013, 09:46 AM
krjoshi Re: VBA / Macro help needed... 05-20-2013, 10:30 AM
krjoshi Re: VBA / Macro help needed... 05-26-2013, 09:40 AM
HaHoBe Re: VBA / Macro help needed... 05-26-2013, 10:22 AM
krjoshi Re: VBA / Macro help needed... 05-26-2013, 10:40 AM
HaHoBe Re: VBA / Macro help needed... 05-26-2013, 10:59 AM
HaHoBe Re: VBA / Macro help needed... 05-26-2013, 11:52 PM
  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