+ Reply to Thread
Results 1 to 7 of 7

Trying to move specific range to a specific sheet based on data in certain column

  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Trying to move specific range to a specific sheet based on data in certain column

    I am having trouble with a macro that I am creating. Here is the scenario: I want to take a range of data from sheet "TEMP" and copy it to a different sheet, based on what is in cell "E" of each row of the "TEMP" sheet. I am getting a "type mismatch" with the code that I have. I am guessing that it is not looking for a string, but a number, and that is why it is giving me the error. I appreciate all of your help!!!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    07-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Trying to move specific range to a specific sheet based on data in certain column

    I am giving this a bump!

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Trying to move specific range to a specific sheet based on data in certain column

    Maybe:


    Dim i as Long
    Dim rowNumber as Long

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Trying to move specific range to a specific sheet based on data in certain column

    Does this do what you want?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Trying to move specific range to a specific sheet based on data in certain column

    @JOHN Thank you for the response! Here is the only problem: If the code runs and finds "Admin Operations" in cell E2, it needs to copy the contents of A2:D2 to the "Admin" sheet range "A123". Of course, this would need to loop through the "TEMP" sheet, which it looks like it already does. I hope that makes sense.

  6. #6
    Registered User
    Join Date
    07-31-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Trying to move specific range to a specific sheet based on data in certain column

    I changed
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    and it seems to be working. Do you see any negative effects to this?

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Trying to move specific range to a specific sheet based on data in certain column

    If it is doing what you want, them I don't see any negative effects. Please comply with Forum Rule No 9, and marked this thread as solved.

+ 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. Move data to specific worksheet based on Column A criteria.
    By forestminuet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2013, 01:44 PM
  2. [SOLVED] Move rows of data from one sheet to another based on specific values of sheet
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2013, 06:21 AM
  3. Replies: 12
    Last Post: 02-21-2013, 12:55 PM
  4. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  5. Move row of data to another sheet once a date is entered in a specific column
    By stankanie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-27-2012, 09:21 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