+ Reply to Thread
Results 1 to 2 of 2

How to copy columns to new sheets based on condition?

  1. #1
    Registered User
    Join Date
    12-15-2008
    Location
    Canada
    Posts
    1

    How to copy columns to new sheets based on condition?

    Hi all ,
    I'm new to vba programming. I'm looking for macro to do the following :
    On my "data" sheet i have listed info in each column about employees. Column A is headers and it's 20 rows long (A1 Name , A2 Age , A3 Nationality etc.) It looks like this :

    A B C
    1 NAME James Mark
    2 AGE 22 18
    3 NATIONALITY English German
    4....
    5...
    20...

    What i'm trying to do is to copy all the employees info with the same nationality to new sheet called whatever their nationality is. This way employees from each country will have designated sheets. Once copied there i want headers next to each column as well.

    By the same token once this is all done and lets say i cleared content from my "data" sheet how do i get back all those emploeeys to my "data" sheet ??
    thanks in advance guys !!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525
    Lets see a sample workbook...

+ 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