+ Reply to Thread
Results 1 to 2 of 2

Copy Row to another Sheet By Value in Column

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    77

    Copy Row to another Sheet By Value in Column

    Hello does anybody know how to cut and copy an entire row based on the value found in Column I. It will need to place it in the corresponding sheet based on the value found in Column I. When it gets to the new sheet it will need to find the first available row and paste it. After that it will need to go back to the first sheet and delete the empty row that was just created by the cut and paste and do this until there are no more values found in column A. Thanks for the help.

  2. #2
    Registered User
    Join Date
    08-19-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    77

    Re: Copy Row to another Sheet By Value in Column

    Sorry I forgot to add the values I'm looking for as well as the sheet names. The Values being looked for are Newspapers-FL, TV-NY, or Radio-CA. The Sheet names are Newspaper,Radio,TV.

+ 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: 3
    Last Post: 01-30-2013, 04:32 PM
  2. Copy Data from one column in a sheet to another column present in 2nd sheet
    By pan07 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2012, 12:50 AM
  3. Copy column data on one sheet to row or column date on another sheet based on user in
    By soready42012 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2012, 12:03 AM
  4. Replies: 0
    Last Post: 05-24-2010, 05:17 PM
  5. Replies: 1
    Last Post: 10-30-2009, 10:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1