+ Reply to Thread
Results 1 to 6 of 6

Moving Rows of data to new worksheet

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    Frankfort, Ky
    MS-Off Ver
    Excel 2010
    Posts
    4

    Moving Rows of data to new worksheet

    Hey I am newer to VBA but I need a macro that helps me move data. I have a master worksheet that is 17k rows long with Column be being a category. I have worksheets made for each category, now I need a macro that will move all of the rows with that category onto the proper sheet. I need it to happen with all categories. There are about 40 categories. Thanks for your help.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Moving Rows of data to new worksheet

    Can you upload a copy of your workbook?

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    Frankfort, Ky
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Moving Rows of data to new worksheet

    Here you go.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Moving Rows of data to new worksheet

    I see no workbook

  5. #5
    Registered User
    Join Date
    03-21-2013
    Location
    Frankfort, Ky
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Moving Rows of data to new worksheet

    It wont let me upload the file. Every time I try it fails. Thoughts?

  6. #6
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Moving Rows of data to new worksheet

    Maybe it is to big of a file size. Try removing unimportant information.

+ 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. Moving column data from one worksheet to rows in another worksheet.
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 09:00 PM
  2. Automatically moving rows to another worksheet which contain certain data
    By whiterosejo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 08:29 PM
  3. Moving rows from one worksheet to another one
    By Abhushan86 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-30-2012, 08:51 AM
  4. Moving Rows To Another Worksheet
    By los7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2009, 01:54 PM
  5. Moving rows of data from one worksheet to another depending on a cells data.
    By Ranny30 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2005, 11:18 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