+ Reply to Thread
Results 1 to 1 of 1

Regarding Copy data from active worksheet in to another file

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2007

    Regarding Copy data from active worksheet in to another file

    Dear Experts,
    I have raised a query regarding copy data from one worksheet to another worksheet and it was successfully worked with the help of Dave.
    Now I am looking that if i want to do the same in another file, how to do it.
    Actually i have made a "Form" file for many users and all files are renamed by users and stored in a same folder.
    I want to create a "Log sheet" File and where any user whenever fill the data in the "Form" file, it will copy and paste special value in the next row of previous data.
    Is it possible to do?
    Or is there any other way to do the same.
    Please help about the same.
    I am here by attaching the file where macros are working within the file.
    I want to move the worksheet as a separate file and if the all users (may be more than 10) fill the data in the "Form" file, it should be coppied in the "Logsheet" file.
    The logsheet file will be always open in my system.
    Have a look and try to resolve the same
    Attached Files Attached Files
    Rajeev Kumar

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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