Results 1 to 14 of 14

VB Code Copy and Paste in different sheet

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code Copy and Paste in different sheet

    Hello:

    Please refer to attached file.
    Shee1 has data.
    I need a VB Code to do the following.
    Need to check if any cell in column B are highlighted.
    If any cell is highligted then i need data from that row column L thru T and copy that data in
    Sheet3 at Cell B2.
    If more then 1 cell is highlighted then do the same again at the next availble cell in coulm B Sheet3

    Let me know if you have any questions.
    Thanks.
    RM
    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. VBA Code to Copy entire sheet and paste in another sheet
    By molly13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2015, 11:45 AM
  2. [SOLVED] Copy and Paste in active sheet VBA code
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2014, 04:43 AM
  3. VBA code to search from different sheet > Copy the row > Paste on different sheet.
    By qpywsqp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2013, 11:13 AM
  4. [SOLVED] VBA code to copy and paste an entire row from one sheet to another
    By emach in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-24-2013, 12:12 PM
  5. Replies: 1
    Last Post: 03-28-2013, 02:49 PM
  6. Sheet code to copy & paste a new row of Info to another sheet
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 05:31 PM
  7. Add sheet. Copy Code & Paste in new Module
    By omnibuster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2008, 03:37 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