Results 1 to 3 of 3

copy specific columns from variable sheet names to specific sheet tab

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,141

    copy specific columns from variable sheet names to specific sheet tab

    I have a workbook with several sheets , my concern is sheet master and workings

    Both have headers in common but differs in column position

    that is header on master sheet is to be copied to workings sheet columns from B TO D which has same headers and so on .

    Some headers need not to be copied from Master and Workings , however my issue that the workbook I recieved all do not have the sheet tab master, but workings tab always exist with same header columns.

    The master sheet alternate name can be named invoicing or Teu No or other but have always same headers

    So an imput box to select sheet and copy to workings sheet as expected results attachement.

    http://www.ozgrid.com/forum/showthread.php?t=202531
    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 rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  2. copy data from multiple sheet to master sheet with specific columns only
    By sinha.riteshabap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 06:59 AM
  3. Replies: 0
    Last Post: 04-11-2013, 05:33 PM
  4. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  5. [SOLVED] Copy variable range from sheet to the last row with a specific blank column in new sheet
    By seputus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2012, 07:29 PM
  6. Copy Specific Columns to new Sheet
    By DNADOC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2010, 10:15 PM
  7. Copy specific columns to specific cell on new sheet
    By jones_net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2010, 02:34 AM

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