Bringing duplicate records of single staff on multiple pages in Excel.
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Bringing duplicate records of single staff on multiple pages in Excel.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Bringing duplicate records of single staff on multiple pages in Excel.

    Hello to everyone
    I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?

  2. #2
    New Member
    Join Date
    Apr 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: On other pages, the macro that lists a duplicate record of a staff on a "new" page

    Herkese selam
    Çok sayfalı bir excel kitabım var. Sayfalarda yinelenen kayıtlar var. Personel kayıtlarını makro ile yeni sayfaya aktarmak mümkün müdür?
    Bilgileriniz için şimdiden teşekkür ederiz.

  3. #3
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,644
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Bringing duplicate records of single staff on multiple pages in Excel.

    Quote Originally Posted by Karadeniz63 View Post
    Hello to everyone
    I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?
    Karadeniz63,

    Welcome to the MrExcel forum.

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

    2. Are you using a PC or a Mac?

    See the following link for ways to display your actual raw data worksheets, and, what the results worksheet, manually formatted by you, should look like:
    https://www.mrexcel.com/forum/board-...forum-use.html

    It is always easier to help and test possible solutions if we could work with your actual file.

    Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

    Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

    Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

    If the workbook contains confidential information, you could replace it with generic data.
    Last edited by hiker95; May 11th, 2019 at 07:00 PM. Reason: add additional information
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  4. #4
    New Member
    Join Date
    Apr 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default On other pages, the macro that lists a duplicate record of a staff on a "new" page

    Hello all I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro? Thanks in advance for your information. Excel 2010 32 bit 12345678914 Identity Numbers, similar records on different pages. How to bring the "N1" cell to the "new" page with the macro as on this page.each page can have more than one record.
    ID Numbers
    Document Number
    Award Year
    Name Surname Appellation Worked Unit Bank Tax Number
    D/K
    Indicator
    Additional indicators
    Reward Amount
    Total Prize
    Sheets Name
    12345678914
    12345678914
    123454
    1998-1
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    1998-Sheet1
    button for macro here
    12345678914
    123454
    1998-2
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    1998-Sheet1
    12345678914
    123454
    1999-3
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    1999
    12345678914
    123454
    1999-4
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    1999
    12345678914
    123454
    1999-5
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    1999
    12345678914
    123454
    2000-6
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2000
    12345678914
    123454
    2000-7
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2000
    12345678914
    123454
    2001-8
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2001
    12345678914
    123454
    2002-9
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2002
    12345678914
    123454
    2002-10
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2002
    12345678914
    123454
    2003-11
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2003
    12345678914
    123454
    2004-12
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2004
    12345678914
    123454
    2004-13
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2004
    12345678914
    123454
    2005-14
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2005
    12345678914
    123454
    2006-15
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2006
    12345678914
    123454
    2007-16
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2007
    12345678914
    123454
    2007-17
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2007
    12345678914
    123454
    2008-18
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2008
    12345678914
    123454
    2009-19
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2009
    12345678914
    123454
    2010-20
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2010
    12345678914
    123454
    2011-21
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2011
    12345678914
    123454
    2011-22
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2011
    12345678914
    123454
    2012-23
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2012
    12345678914
    123454
    2012-24
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2012
    12345678914
    123454
    2012-25
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2012
    12345678914
    123454
    2013-26
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2013
    12345678914
    123454
    2013-27
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2013
    12345678914
    123454
    2013-28
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2013
    12345678914
    123454
    2014-29
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2014
    12345678914
    123454
    2015-30
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2015-Sheet
    12345678914
    123454
    2015-31
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2015-Sheet
    12345678914
    123454
    2015-32
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2015-Sheet
    12345678914
    123454
    2015-33
    Kris Marrier Police officer Child Branch Office TR121234123412341234123412
    2/3
    1265
    1600
    2
    472,46
    2015-Sheet
    Sheet: list
    12345678914 Identity Numbers, similar records on different pages. How to bring the "N1" cell to the "new" page with the macro as on this page.each page can have more than one record.

  5. #5
    New Member
    Join Date
    Apr 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: macro that lists a duplicate record of a staff in other pages on a "new" page

    Bay: hiker 95
    İlginiz için teşekkürler.
    Windows 7 Ultimate, Excel-2010 kullanıyorum.

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

    Default Re: macro that lists a duplicate record of a staff in other pages on a "new" page

    Karadeniz63,

    Thanks for the screenshot of worksheet list.

    1. Do all of the worksheets in worksheet list, column M, already exist?

    2. Are there formulas in any of the cells in worksheet list?
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  7. #7
    New Member
    Join Date
    Apr 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: macro that lists a duplicate record of a staff in other pages on a "new" page

    Sayın; hiker95
    Teşekkürler efendim.
    Çalışma listesi listesindeki hücrelerin hiçbirinde formül yoktur.
    "M" sütunu gerekli değildir; Önemli değil.

  8. #8
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,644
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    8 Thread(s)

    Default Re: macro that lists a duplicate record of a staff in other pages on a "new" page

    Karadeniz63,

    1. Can we have a screenshot of worksheet 1999 before the macro?

    2. Can we have a screenshot of worksheet 1999 after the macro?
    Last edited by hiker95; May 12th, 2019 at 09:26 AM.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  9. #9
    New Member
    Join Date
    Apr 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: macro that lists a duplicate record of a staff in other pages on a "new" page

    Dear; hiker95
    Thank you sir.
    There is no formula in any of the cells in the work list list.
    The "M" column is not required; Not important.

  10. #10
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,644
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    8 Thread(s)

    Default Re: macro that lists a duplicate record of a staff in other pages on a "new" page

    Quote Originally Posted by Karadeniz63 View Post
    Sayın; hiker95
    Teşekkürler efendim.
    Çalışma listesi listesindeki hücrelerin hiçbirinde formül yoktur.
    "M" sütunu gerekli değildir; Önemli değil.
    Karadeniz63,

    I can not help you if your are going to communicate in a different language.

    Maybe someone else on MrExcel will be able to help you.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

Some videos you may like

User Tag List

Tags for this Thread

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
  •