JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Bringing duplicate records of single staff on multiple pages in Excel.
Hello to everyone
How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Re: On other pages, the macro that lists a duplicate record of a staff on a "new" page
Hello to everyone
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: May 11, 2019
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.
[TABLE="class: head"]ID
[/TD]Document
[/TD]Award
[/TD]Name Surname Appellation Worked Unit Bank Tax Number D/K
[/TD]Indicator
[/TD]Additional
[/TD]Reward Amount
[/TD]Total Prize
[/TD]Sheets Name
[/TD]12345678914
[/TD]12345678914
[/TD]123454
[/TD]1998-1
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]1998-Sheet1
[/TD]12345678914
[/TD]123454
[/TD]1998-2
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]1998-Sheet1
[/TD]12345678914
[/TD]123454
[/TD]1999-3
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]1999
[/TD]12345678914
[/TD]123454
[/TD]1999-4
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]1999
[/TD]12345678914
[/TD]123454
[/TD]1999-5
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]1999
[/TD]12345678914
[/TD]123454
[/TD]2000-6
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2000
[/TD]12345678914
[/TD]123454
[/TD]2000-7
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2000
[/TD]12345678914
[/TD]123454
[/TD]2001-8
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2001
[/TD]12345678914
[/TD]123454
[/TD]2002-9
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2002
[/TD]12345678914
[/TD]123454
[/TD]2002-10
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2002
[/TD]12345678914
[/TD]123454
[/TD]2003-11
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2003
[/TD]12345678914
[/TD]123454
[/TD]2004-12
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2004
[/TD]12345678914
[/TD]123454
[/TD]2004-13
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2004
[/TD]12345678914
[/TD]123454
[/TD]2005-14
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2005
[/TD]12345678914
[/TD]123454
[/TD]2006-15
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2006
[/TD]12345678914
[/TD]123454
[/TD]2007-16
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2007
[/TD]12345678914
[/TD]123454
[/TD]2007-17
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2007
[/TD]12345678914
[/TD]123454
[/TD]2008-18
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2008
[/TD]12345678914
[/TD]123454
[/TD]2009-19
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2009
[/TD]12345678914
[/TD]123454
[/TD]2010-20
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2010
[/TD]12345678914
[/TD]123454
[/TD]2011-21
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2011
[/TD]12345678914
[/TD]123454
[/TD]2011-22
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2011
[/TD]12345678914
[/TD]123454
[/TD]2012-23
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2012
[/TD]12345678914
[/TD]123454
[/TD]2012-24
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2012
[/TD]12345678914
[/TD]123454
[/TD]2012-25
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2012
[/TD]12345678914
[/TD]123454
[/TD]2013-26
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2013
[/TD]12345678914
[/TD]123454
[/TD]2013-27
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2013
[/TD]12345678914
[/TD]123454
[/TD]2013-28
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2013
[/TD]12345678914
[/TD]123454
[/TD]2014-29
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2014
[/TD]12345678914
[/TD]123454
[/TD]2015-30
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2015-Sheet
[/TD]12345678914
[/TD]123454
[/TD]2015-31
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2015-Sheet
[/TD]12345678914
[/TD]123454
[/TD]2015-32
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2015-Sheet
[/TD]12345678914
[/TD]123454
[/TD]2015-33
[/TD]2/3
[/TD]1265
[/TD]1600
[/TD]2
[/TD]472,46
[/TD]2015-Sheet
[/TD] [TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet:
list [/TD]
[/TR]
[TR]
[TD]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.[/TD]
[/TR]
</tbody>[/TABLE]
Re: macro that lists a duplicate record of a staff in other pages on a "new" page
Re: macro that lists a duplicate record of a staff in other pages on a "new" page list .list , column M, already exist?list ?
Re: macro that lists a duplicate record of a staff in other pages on a "new" page
Re: macro that lists a duplicate record of a staff in other pages on a "new" page 1999 before the macro?1999 after the macro?
Last edited: May 12, 2019
Re: macro that lists a duplicate record of a staff in other pages on a "new" page
Re: macro that lists a duplicate record of a staff in other pages on a "new" page
Sayın; hiker95
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.
Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast
