+ Reply to Thread
Results 1 to 3 of 3

Data copy Automatically into closed work book

  1. #1
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Data copy Automatically into closed work book

    Dear Experts,
    Greetings!
    I have one question as below: -
    I have a folder in D:\A and there are more than 5 files (a1.xlsm, a2.xlsm, a3.xlsm, a4.xlsm & a5.xlsm. Each file one worksheet is common named "WODET".
    Now I want to enter data in sheet "WODET" in a1.xlsm and the same should update in all files in the folder in sheet "WODET".
    Please help me.
    In advance thanks.
    Rajeev Kumar

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Data copy Automatically into closed work book

    Hi
    Have a look at this link which will explain how to do what you want:

    http://office.microsoft.com/en-gb/ex...010102338.aspx

    Good luck.
    Tony

  3. #3
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Re: Data copy Automatically into closed work book

    Dear Experts,
    can i get an example file for the same to understand it.

    Thanks/Regards,

+ Reply to Thread

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