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

[Karadeniz63]

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?

 

[hiker95]

Re: macro that lists a duplicate record of a staff in other pages on a "new" page

Karadeniz63,

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.

 

[Karadeniz63]

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.


http://s2.dosya.tc/server8/cyjdg4/d_of_a_staff_in_other_pages_on_a_new_page.rar.html

 

[hiker95]

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.


http://s2.dosya.tc/server8/cyjdg4/d_of_a_staff_in_other_pages_on_a_new_page.rar.html

Karadeniz63,

Your current link to your workbook/worksheets is in a different language.

I can not help you.

Maybe someone else on MrExcel will be able to assist you.

 

[Karadeniz63]

macro that lists a duplicate record of a staff in other pages on a "new" page

hello all again.

I'm sure I'il get an answer. I hope. I also sent a link for a screenshot and file.

thanks again.

http://s2.dosya.tc/server8/cyjdg4/d_of_a_staff_in_other_pages_on_a_new_page.rar.html

 

[hiker95]

Re: macro that lists a duplicate record of a staff in other pages on a "new" page

hello all again.

I'm sure I'il get an answer. I hope. I also sent a link for a screenshot and file.

thanks again.

http://s2.dosya.tc/server8/cyjdg4/d_of_a_staff_in_other_pages_on_a_new_page.rar.html

Karadeniz63,

Your current link to your workbook/worksheets is in a different language.

I can not help you.

Maybe someone else on MrExcel will be able to assist you.