Results 1 to 6 of 6

need help on vba copy range from closedwb to active masterwb

Threaded View

breadwinner need help on vba copy range... 12-25-2013, 11:27 PM
fredlo2010 Re: need help on vba copy... 12-25-2013, 11:54 PM
jindon Re: need help on vba copy... 12-26-2013, 12:12 AM
fredlo2010 Re: need help on vba copy... 12-26-2013, 12:17 AM
jindon Re: need help on vba copy... 12-26-2013, 02:34 AM
breadwinner Re: need help on vba copy... 12-26-2013, 02:18 AM
  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    need help on vba copy range from closedwb to active masterwb

    Dear Experts

    I need ur help here

    I want copy the range of cell value (E11:M33) from closed workbook paste into same set of range of cells with pastespecial values into master file

    I have set of range in closedworkbook called(COPYWB.XLS) ,in particular location C:\Users\aruna\Desktop\CTOP\COPYWB.XLS(sheet name is DASHBOARD)
    for copy the range of cell (E11:M33) from this workbook and paste (E11:M33) same range into MASTER WORKBOOK(DASHBOARD SHEET) (E11:M33)With pastespecialvalues..

    I add two command button in MASTERWB..one button pull data , another button clear the data on range ,,keep empty

    find the attachment... COPYWB IS value copy from this wb,MASTER is value paste into this wb...

    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy active cell to end of range
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2013, 12:02 AM
  2. [SOLVED] Copy data from MasterWB and paste to WB1 while WB1 is open by someone else?
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 12:27 AM
  3. Copy range into active cell
    By jeff p in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2009, 03:48 PM
  4. copy active range
    By sammar12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2009, 03:42 PM
  5. [SOLVED] To copy from a range in another sheet to the active cell
    By raja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2005, 12:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1