+ Reply to Thread
Results 1 to 5 of 5

vba copy specific column with yellow background and their data to another sheet

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

    vba copy specific column with yellow background and their data to another sheet

    I have a workbook with a data sheet from which headers are at Row 3 from column A to AT

    Below the headers are data of different formatting .

    How to copy in vba the headers at row 3 in yellow background and their column data to last row to another sheet named Working keeping their formatting .

    Note there may be some in yellow columns headers that have blank cells that is aaa , blank ,blank , aaa and so on .

    the data reads from 20000 rows records or more

    Attached file with expected results .

    Thanks if someone can assist
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: vba copy specific column with yellow background and their data to another sheet

    try this

    Please Login or Register  to view this content.
    Teach me Excel VBA

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: vba copy specific column with yellow background and their data to another sheet

    Change the sheet name for output.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: vba copy specific column with yellow background and their data to another sheet

    Try
    Please Login or Register  to view this content.

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

    Re: vba copy specific column with yellow background and their data to another sheet

    Hello Imran

    Tried your method but did not work.

    Jindon thank you working as a charm .
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 07-15-2018, 06:27 PM
  2. [SOLVED] Copy specific column data from one sheet to another sheet using Certain filter Criteria
    By xlhelp7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2017, 12:09 AM
  3. [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
  4. Count if Same Text name AND Same Background Color Yellow
    By ORAM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2012, 12:15 PM
  5. [SOLVED] Find all cells with a specific background color then copy/paste to correct column
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-20-2012, 10:18 AM
  6. Macro/Module running as background process, copy data from sheet to sheet
    By ctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2009, 05:48 AM
  7. [SOLVED] How do you count cells with background color yellow?
    By Stephanie D in forum Excel General
    Replies: 6
    Last Post: 10-18-2005, 12:05 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