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?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Karadeniz63

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

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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:

Karadeniz63

New Member
Joined
Apr 28, 2019
Messages
9
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 SurnameAppellationWorked UnitBank Tax Number
D/K
Indicator
Additional
indicators
Reward Amount
Total Prize
Sheets Name
12345678914​
12345678914​
123454​
1998-1​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
1998-Sheet1
button for macro here
12345678914​
123454​
1998-2​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
1998-Sheet1
12345678914​
123454​
1999-3​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
1999
12345678914​
123454​
1999-4​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
1999
12345678914​
123454​
1999-5​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
1999
12345678914​
123454​
2000-6​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2000
12345678914​
123454​
2000-7​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2000
12345678914​
123454​
2001-8​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2001
12345678914​
123454​
2002-9​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2002
12345678914​
123454​
2002-10​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2002
12345678914​
123454​
2003-11​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2003
12345678914​
123454​
2004-12​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2004
12345678914​
123454​
2004-13​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2004
12345678914​
123454​
2005-14​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2005
12345678914​
123454​
2006-15​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2006
12345678914​
123454​
2007-16​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2007
12345678914​
123454​
2007-17​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2007
12345678914​
123454​
2008-18​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2008
12345678914​
123454​
2009-19​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2009
12345678914​
123454​
2010-20​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2010
12345678914​
123454​
2011-21​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2011
12345678914​
123454​
2011-22​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2011
12345678914​
123454​
2012-23​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2012
12345678914​
123454​
2012-24​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2012
12345678914​
123454​
2012-25​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2012
12345678914​
123454​
2013-26​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2013
12345678914​
123454​
2013-27​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2013
12345678914​
123454​
2013-28​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2013
12345678914​
123454​
2014-29​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2014
12345678914​
123454​
2015-30​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2015-Sheet
12345678914​
123454​
2015-31​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2015-Sheet
12345678914​
123454​
2015-32​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2015-Sheet
12345678914​
123454​
2015-33​
Kris MarrierPolice officerChild Branch OfficeTR121234123412341234123412
2/3​
1265​
1600​
2​
472,46​
2015-Sheet

<tbody>
</tbody>
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.

<tbody>
</tbody>
 

Karadeniz63

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

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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?
 

Karadeniz63

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

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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:

Karadeniz63

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

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,028
Messages
5,447,946
Members
405,474
Latest member
faworange

This Week's Hot Topics

Top