+ Reply to Thread
Results 1 to 3 of 3

Complicated Macro

  1. #1
    Registered User
    Join Date
    02-01-2005
    Posts
    7

    Complicated Macro

    I need help. Whoever helps me get this gets a prize. I am trying to make a macro that will look through a column and copy & paste rows that match a certain criteria to a certain sheet in the workbook.
    ie. if A1 = "A" then it would paste the entire row into sheet2, if A1 = "b" then it would paste the entire row to sheet3.

    The part I am having the most trouble with is figuring out how to make it paste in the first open row and not over-write something already filled. If it would help to give you what I have so far let me know. THANKS!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello,

    Be glad to help. I'm not sure though what you are wanting to do. When you say Row to mean Across or Down the worksheet? Also, do you want the macro to paste the data into the next available row on the worksheet (row meaning across) automatically?

    Let me know,
    Leith Ross

  3. #3
    Registered User
    Join Date
    02-01-2005
    Posts
    7
    I have five sheets, the first has a list and the next 4 are blank. I want a macro to go through the list on the first sheet and depending on what the value of the cells are it would move the whole row to the corresponding sheet.

    When I say Row I mean across the sheet.

+ 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