+ Reply to Thread
Results 1 to 7 of 7

Moving and Deleting Data from Sheet1 to other sheets in same Workbook

  1. #1
    Registered User
    Join Date
    04-23-2009
    Location
    Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    I have 10 columns of data with up to 30,000 rows. I need to search for different numbers in column C and paste the row(s) of data found onto different sheets. Example: search for all of the “12345” numbers in column C. Each time it finds the number “12345” cut the complete row of data from Sheet 1 paste it onto Sheet 2. It must continue this loop until all rows of column C have been searched. Then search for number “78910” using the same process, search for number “13579” using the same process, etc.

    I do have 3 numbers that will need to go to the same Sheet, call it Sheet 5. Example: search Sheet 1 for “24680” and “54321” and “98765”, cut the complete rows of data from Sheet 1 and paste it onto Sheet 5.

    I have a working program but I am very new to VBA and not very good. The program I have created will not delete the data but will paste it to the individual Sheets.

  2. #2
    Registered User
    Join Date
    08-20-2008
    Location
    Philippines
    MS-Off Ver
    Office 2007
    Posts
    18

    Re: Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    Hi,

    Maybe this sample could help you.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Thumbs up Re: Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    Hi,

    This loop might help:

    Please Login or Register  to view this content.
    --Karan--

  4. #4
    Registered User
    Join Date
    04-23-2009
    Location
    Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    Karan,

    I did get it to work. However, I have (2) rows of calculations at the top of each sheet, rows 1 and 2, and when the data is pasted into the sheet it moves the row 2 calculations below the pasted data. As I mentioned before, I am very new to this but I did try to correct the issue, to no avail. Do you have a any ideas?

    Thanks

  5. #5
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Thumbs up Re: Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    Try this:

    Please Login or Register  to view this content.
    --Karan--

  6. #6
    Registered User
    Join Date
    04-23-2009
    Location
    Mississippi
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    Karan,

    That did fix the problem. Thanks.

  7. #7
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Smile Re: Moving and Deleting Data from Sheet1 to other sheets in same Workbook

    If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

    --Karan--

+ 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