+ Reply to Thread
Results 1 to 7 of 7

VBA for copying range based on tab name and order from diferent tab

  1. 05-16-2019, 06:26 AM #1
    LucyStark
    LucyStark is offline
    Registered User
    Join Date
    05-16-2019
    Location
    Coventry, England
    MS-Off Ver
    2019
    Posts
    5

    VBA for copying range based on tab name and order from diferent tab

    hi All,

    I hope someone can help me, it has been a nightmare now. I'm failing to get the code right to be able to copy range from tab based on its name in other sheet.
    To explain it better: I have tabs like Press, Laser etc and one tab called Generate that was operations listed in order in range "B2:B15".
    So if the first operation in cell "B2" is Press I need it to go to Press Tab and grab the range that in not empty and then copy that into the new workbook. Then it needs to go back to "B3" and copy and paste underneath the previous one.

    can someone help, please?

    Lucy
    Reply With QuoteRegister To Reply
  2. 05-16-2019, 11:59 AM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA for copying range based on tab name and order from diferent tab

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 05-17-2019, 02:04 AM #3
    LucyStark
    LucyStark is offline
    Registered User
    Join Date
    05-16-2019
    Location
    Coventry, England
    MS-Off Ver
    2019
    Posts
    5

    Re: VBA for copying range based on tab name and order from diferent tab

    Hi Xladept,

    thank you for your reply!
    please find sample workbook attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-17-2019, 02:33 AM #4
    huuthang_bd
    huuthang_bd is offline
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: VBA for copying range based on tab name and order from diferent tab

    Try this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-17-2019, 02:40 AM #5
    LucyStark
    LucyStark is offline
    Registered User
    Join Date
    05-16-2019
    Location
    Coventry, England
    MS-Off Ver
    2019
    Posts
    5

    Re: VBA for copying range based on tab name and order from diferent tab

    OMG you must be a genius!!!
    that's amazing!
    you have no idea how long I have been struggling with that...

    thank you so much!!!
    Reply With QuoteRegister To Reply
  6. 05-17-2019, 03:01 AM #6
    huuthang_bd
    huuthang_bd is offline
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: VBA for copying range based on tab name and order from diferent tab

    Glad to have helped you!
    Reply With QuoteRegister To Reply
  7. 05-17-2019, 11:24 AM #7
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA for copying range based on tab name and order from diferent tab

    Hi Lucy,

    I'm glad that your problem is solved. Thanks for the rep!

    *Please choose thread tools and mark this post as solved
    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. Send diferent emails based on range value
    By Fandrinella in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2019, 09:03 AM
  2. [SOLVED] Check if range of cells are in ascending order based on repeating data in another cell
    By mgcarino14 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2016, 09:17 AM
  3. Monthly cost in wages based on employee start/end dates (diferent departments)
    By ctechau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2016, 08:29 PM
  4. Formula to add diferent mark ups based on origina price
    By Ricky.Sherman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2015, 07:04 PM
  5. [SOLVED] Counting number of non blank cells based on contents of diferent range
    By icyoung in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-14-2013, 12:14 PM
  6. how to select a range that start in diferent row
    By Pasmatos in forum Excel General
    Replies: 2
    Last Post: 11-28-2005, 03:10 PM
  7. copying dynamic range based on cell outside of range
    By xcelelder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2005, 12:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1