+ Reply to Thread
Results 1 to 3 of 3

Copy Column A from Sheet containing Specific Word and Past it into last sheet

  1. 07-31-2015, 01:19 AM #1
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Copy Column A from Sheet containing Specific Word and Past it into last sheet

    Hii Freinds...

    I Want to Copy Col A from sheets containting word say Company 1 to the last sheet i.e. Bonus

    Edit: Last sheet formula.
    Attached Files Attached Files
    Last edited by mangesh.mehendale; 07-31-2015 at 01:26 AM. Reason: change attactment
    Don`t care, take care...

    Regards,
    Mangesh
    Reply With QuoteRegister To Reply
  2. 07-31-2015, 09:13 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy Column A from Sheet containing Specific Word and Past it into last sheet

    Does this help?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 08-01-2015, 01:04 AM #3
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Copy Column A from Sheet containing Specific Word and Past it into last sheet

    No it is not working I have shown results in Col A in Sheet- Bonus Co 1
    It is pasting only one employee i.e. ABC...

    Is there other solution with remove duplications??
    or any other idea to get unique employees in last sheet "Bonus Co 1"
    Last edited by mangesh.mehendale; 08-01-2015 at 01:06 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy cells in another sheet if 1st sheet has a certain color in a specific column
    By ccellarius32 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2014, 05:08 PM
  2. Automatic COPY and PAST entire Column to another sheet column
    By irfanfun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2014, 09:38 AM
  3. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  4. Move row data to a specific sheet if column contains specific word
    By Kennethc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2014, 06:55 PM
  5. VBA Copy and past with in a Column of a sheet
    By _google in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2013, 02:13 PM
  6. [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
  7. [SOLVED] Seach for data from one sheet to another sheet and copy past adjacent columns
    By mahtabshaikh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2012, 10:19 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1