+ Reply to Thread
Results 1 to 1 of 1

Copy same range from main WorkBook WorkSheet1,always open new WorkBook WorkSheet1 & paste

  1. #1
    Forum Contributor
    Join Date
    10-17-2014
    Location
    EU
    MS-Off Ver
    2013
    Posts
    114

    Copy same range from main WorkBook WorkSheet1,always open new WorkBook WorkSheet1 & paste

    I have one main workbook (MAIN) with plenty of sheets. I would need a macro that would enable me every time to copy columns A, C, F, Y from Sheet1 in my MAIN workbook then always open a new workbook and paste range in its' Sheet1.

    Any ideas would be helpful.

    Thank you!
    Last edited by Tona; 01-11-2016 at 02:37 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open all workbooks in a folder and copy the first seeht> Paste to New Main workbook.
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2014, 01:56 PM
  2. VBA to copy range from one workbook and paste to another open workbook
    By lilvictorians in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2013, 03:06 PM
  3. Simple task: Open a workbook, copy a range, paste into another workbook
    By fbonetti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2011, 01:12 PM
  4. VBA Code to copy data from Worksheet1 to Worksheet2
    By bruce2444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2009, 04:44 PM
  5. copy all rows from worksheet1 with matching value to worksheet2?
    By mjpeters in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2007, 04:58 PM
  6. Open Worksheet1
    By JUBA in forum Excel General
    Replies: 2
    Last Post: 04-21-2007, 01:01 PM
  7. linking worksheet1 to worksheet1
    By Bed in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-26-2005, 01:06 PM

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