Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 25

Thread: Copy certain row to new sheet

  1. #1
    New Member
    Join Date
    Dec 2013
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copy certain row to new sheet

    Dear all,

    i would like to copy each new order start from row "PH Order No:" to "0" to new sheet.
    for below example, i would like to separate 4 order to 4 sheet.

    Please help!!!



  2. #2
    New Member
    Join Date
    Dec 2013
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy certain row to new sheet

    push

  3. #3
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Copy certain row to new sheet

    Can't access the image.
    Try using the HTML Maker in my tag..to post a SMALL sample of your data, and what you need done !
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  4. #4
    New Member
    Join Date
    Dec 2013
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy certain row to new sheet

    Quote Originally Posted by Michael M View Post
    Can't access the image.
    Try using the HTML Maker in my tag..to post a SMALL sample of your data, and what you need done !

    sorry, i cannot download the HTML Maker

    my sheet is like that (on 1 column)

    Order No:
    1
    2
    3

    Order No.
    1
    2
    3
    4
    5

    Order No.
    1
    2

    Order No.
    1
    2
    3
    4
    5
    6

    and i would like to cut each order no. to a new sheet.
    Thank you!!!

  5. #5
    New Member
    Join Date
    Dec 2013
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy certain row to new sheet

    *Not only the row order no.
    but the number row under each order no.

  6. #6
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Copy certain row to new sheet

    MAybe this
    Code:
    Sub MM1()
    Dim lr As Long, r As Long, x As Long, ns As Worksheet
    Set ns = Sheets("Sheet1")
    lr = ns.Cells(Rows.Count, "A").End(xlUp).Row
    x = 0
    For r = 2 To lr
        If ns.Range("A" & r).Value <> "" Then x = x + 1
            If ns.Range("A" & r).Value = "" Then
                Sheets.Add After:=Sheets(Worksheets.Count)
                ns.Rows(r - x & ":" & r).Copy
                ActiveSheet.Paste
                x = 0
            End If
    Next r
    End Sub
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  7. #7
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,583
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Copy certain row to new sheet

    miracleyy,

    1. What version of Excel and Windows are you using?

    2. Are you using a PC or a Mac?


    So that we can get it right this next time:

    How about posting your workbook/worksheets:
    1. With the raw data in its actual worksheet name
    2. And, the resulting worksheets manually formatted by you for the results you are looking for.

    You can upload your workbook to Box Net,
    sensitive data changed
    mark the workbook for sharing
    and provide us with a link to your workbook.
    Last edited by hiker95; Jun 18th, 2014 at 10:45 PM.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  8. #8
    New Member
    Join Date
    Dec 2013
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy certain row to new sheet

    Quote Originally Posted by Michael M View Post
    MAybe this
    Code:
    Sub MM1()
    Dim lr As Long, r As Long, x As Long, ns As Worksheet
    Set ns = Sheets("Sheet1")
    lr = ns.Cells(Rows.Count, "A").End(xlUp).Row
    x = 0
    For r = 2 To lr
        If ns.Range("A" & r).Value <> "" Then x = x + 1
            If ns.Range("A" & r).Value = "" Then
                Sheets.Add After:=Sheets(Worksheets.Count)
                ns.Rows(r - x & ":" & r).Copy
                ActiveSheet.Paste
                x = 0
            End If
    Next r
    End Sub

    Thank you!!
    But it did not work. No response.

  9. #9
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    16,585
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Copy certain row to new sheet

    Are you copying from the sheet named "Sheet1" AND Column "1" ??
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  10. #10
    New Member
    Join Date
    Dec 2013
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy certain row to new sheet

    Quote Originally Posted by Michael M View Post
    Are you copying from the sheet named "Sheet1" AND Column "1" ??
    Yes.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •