+ Reply to Thread
Results 1 to 5 of 5

copy the particular worksheet from closed wb,paste as individual worksheet into master vba

  1. 01-01-2014, 02:11 AM #1
    johnodys
    johnodys is offline
    Forum Contributor
    Join Date
    07-23-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    143

    copy the particular worksheet from closed wb,paste as individual worksheet into master vba

    Dear Expert

    Need help on vba I have multiple workbooks in particular folder.. and one master file i want pull particular worksheet from all workbooks in that folder and save copied worksheet as extract date of file every file name...

    if i have one workbook OPENCALL_01-01-2014.XLSB In that one sheet is OPENCALL... I want to save the opencall sheet into seperate worksheet in that masterfile. as 01-01-2014,
    if i have another one workbook OPENCALL_02-01-2014.XLSB In that one sheet is OPENCALL... I want to save the opencall sheet into seperate new worksheet in that masterfile. as 02-01-2014, like that continue till find worksheet Opencall in all workbook......

    every workbooks ends with date only after _

    main complication is rename sheet with file name date =RIGHT(FILENAME,10) so save sheet as 01-01-2013
    loop till how many workbooks exist with worksheet(OPENCALL) in that Path "D:\Documents and Settings\Administrator\Desktop\NEW FORUM"

    find the attachment you may understand my requirement
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-01-2014, 03:36 AM #2
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: copy the particular worksheet from closed wb,paste as individual worksheet into master

    I am working on your query.......
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
    Reply With QuoteRegister To Reply
  3. 01-01-2014, 05:27 AM #3
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: copy the particular worksheet from closed wb,paste as individual worksheet into master

    Hi John

    Try the attached Master file.

    step:
    1) In setup worksheet tab change the file path & make sure that master should not be there in that path
    2) Keep this attached Master file anywhere you want but not in file path mention in worksheets

    last click on the assign button and see the magic.

    Hope this will work
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-02-2014, 02:27 AM #4
    johnodys
    johnodys is offline
    Forum Contributor
    Join Date
    07-23-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    143

    Re: copy the particular worksheet from closed wb,paste as individual worksheet into master

    Perfect Naveed!!! Its works Perfectly....cool !!!Happy New Year 2014 to you and your famile's Solved
    Reply With QuoteRegister To Reply
  5. 01-02-2014, 10:25 AM #5
    Naveed Raza
    Naveed Raza is offline
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: copy the particular worksheet from closed wb,paste as individual worksheet into master

    Glad i could help

    If the suggestion helps you, then Click * to Add Reputation & give your valuable comments

    Happy New Year 2014 to you and to your family
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do you copy and paste duplicate rows on a master worksheet with corrollating formulas
    By arjoyce in forum Excel General
    Replies: 11
    Last Post: 10-11-2013, 12:16 AM
  2. Copy a row from master sheet and paste it to a specific worksheet based on tab name
    By obrie499 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 10:45 AM
  3. Separate Data from Master Worksheet into Individual Worksheets
    By bhenderson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2011, 02:14 PM
  4. copy rows from master worksheet to individual worksheets by cell value???
    By whittace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2010, 10:49 AM
  5. Generate a master worksheet from individual worksheets
    By Bond007 in forum Excel General
    Replies: 16
    Last Post: 12-17-2009, 10:57 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1