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

K

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 can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
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
Karadeniz63 said:
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?
Click to expand...

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

Karadeniz63 said:
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.
Click to expand...

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
You must log in or register to reply here.

Similar threads

Skrej
  • Question Question
Random page margin spilling over
Replies
4
Views
190
Skrej
Skrej
S
  • Question Question
VBA : Reflection Workspace extract all screen/pages
Replies
0
Views
111
Samantha27
S
B
  • Question Question
Using VBA to retrieve specific pages from PDFs
Replies
1
Views
123
Big_Al_fae_the_rigs
B
J
  • Question Question
Duplicate Sheets in Excel VBA Project
Replies
1
Views
160
jkpieterse
jkpieterse
W
  • Question Question
Excel VBA - Check For Duplicates and Return the Count on a Large Data Set
Replies
4
Views
319
Kaper
Kaper

Forum statistics

Threads
1,223,992
Messages
6,175,822
Members
452,672
Latest member
missbanana

Share this page

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