+ Reply to Thread
Results 1 to 2 of 2

Move selcted cells linked tabs to new work book

  1. #1
    Forum Contributor
    Join Date
    05-25-2020
    Location
    Madurai
    MS-Off Ver
    Excel 2010
    Posts
    136

    Post Move selcted cells linked tabs to new work book

    Hi

    Seeking some one help to create VBA code for the below.

    I have one consolidated workbook its having summary tab. And Summary TAB Column G is linked with other TAB in same work Book.
    And Column F is sub total of Column E.

    If user Select Column G Cells, the linked tab and entire row of Cell Selected
    to be Moved to New Workbook

    If user selected Column G and its having Sub Total in F, then Sub Total Rows
    and corresponding linked TAB to be moved to new work book

    Sample out files are attached
    Attached Files Attached Files
    Last edited by KKR1975; 05-07-2021 at 12:01 AM.

  2. #2
    Forum Contributor
    Join Date
    05-25-2020
    Location
    Madurai
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Move selcted cells linked tabs to new work book

    Any help on this requirements

+ 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. Move Data From one work book based criteria
    By nr6281 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2019, 03:33 PM
  2. [SOLVED] Move Data From one work book to another with Criteria
    By nr6281 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2019, 02:54 PM
  3. [SOLVED] Vba to open closed tabs in a work book then close them
    By mmikem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2018, 07:09 PM
  4. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  5. Replies: 5
    Last Post: 03-03-2014, 01:53 AM
  6. Replies: 3
    Last Post: 02-24-2014, 02:39 PM
  7. Help with SUM() Multiple cells from linked book
    By braddach in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 11:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1