+ 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
    EXCEL 2016
    Posts
    971

    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 XP to Office 2016
    Posts
    1,624

    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 XP to Office 2016
    Posts
    1,624

    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
    Posts
    14,544

    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
    EXCEL 2016
    Posts
    971

    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)

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