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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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.
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>
 
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,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

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