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

Karadeniz63

New Member
Joined
Apr 28, 2019
Messages
9
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?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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.
 
Upvote 0
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:
Upvote 0
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"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FFFF00"]
ID
Numbers
[/TD]
[TD="bgcolor: #FFFF00"]
Document
Number
[/TD]
[TD="bgcolor: #FFFF00"]
Award
Year
[/TD]
[TD="bgcolor: #FFFF00"]Name Surname[/TD]
[TD="bgcolor: #FFFF00"]Appellation[/TD]
[TD="bgcolor: #FFFF00"]Worked Unit[/TD]
[TD="bgcolor: #FFFF00"]Bank Tax Number[/TD]
[TD="bgcolor: #FFFF00"]
D/K
[/TD]
[TD="bgcolor: #FFFF00"]
Indicator
[/TD]
[TD="bgcolor: #FFFF00"]
Additional
indicators
[/TD]
[TD="bgcolor: #FFFF00"]
Reward Amount
[/TD]
[TD="bgcolor: #FFFF00"]
Total Prize
[/TD]
[TD="bgcolor: #FFFF00"]
Sheets Name
[/TD]
[TD]
12345678914​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
1998-1​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
1998-Sheet1
[/TD]
[TD="align: center"]button for macro here[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
1998-2​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
1998-Sheet1
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
1999-3​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
1999
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
1999-4​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
1999
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
1999-5​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
1999
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2000-6​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2000
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2000-7​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2000
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2001-8​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2001
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2002-9​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2002
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2002-10​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2002
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2003-11​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2003
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2004-12​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2004
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2004-13​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2004
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2005-14​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2005
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2006-15​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2006
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2007-16​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2007
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2007-17​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2007
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2008-18​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2008
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2009-19​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2009
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2010-20​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2010
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2011-21​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2011
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2011-22​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2011
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2012-23​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2012
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2012-24​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2012
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2012-25​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2012
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2013-26​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2013
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2013-27​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2013
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2013-28​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2013
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2014-29​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2014
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-30​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-Sheet
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-31​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-Sheet
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-32​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-Sheet
[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #FF99FF"]
12345678914​
[/TD]
[TD="bgcolor: #FF99FF"]
123454​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-33​
[/TD]
[TD="bgcolor: #FF99FF"]Kris Marrier[/TD]
[TD="bgcolor: #FF99FF"]Police officer[/TD]
[TD="bgcolor: #FF99FF"]Child Branch Office[/TD]
[TD="bgcolor: #FF99FF"]TR121234123412341234123412[/TD]
[TD="bgcolor: #FF99FF"]
2/3​
[/TD]
[TD="bgcolor: #FF99FF"]
1265​
[/TD]
[TD="bgcolor: #FF99FF"]
1600​
[/TD]
[TD="bgcolor: #FF99FF"]
2​
[/TD]
[TD="bgcolor: #FF99FF"]
472,46​
[/TD]
[TD="bgcolor: #FF99FF"]
2015-Sheet
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[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]
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
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:
Upvote 0
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.
 
Upvote 0
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.

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.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top