Taking columns from sheets

[Serdarrk]

Hello,

The following single file contains approximately 250 pages named by date. I need that opening new page in the file and take all pages' Y and Z columns starting from new page's D columns (I have to enter the names of the first three columns). I don't know it is possible but an other need when code copy and paste all Y and Z columns to new page, it must copy and paste name of every page to top of Y and Z columns (to 3.row). I hope I could tell. I will be very happy if you can help with this.


http://s7.dosya.tc/server3/9r93ou/01.02.2000-1.xls.html

 

[Serdarrk]

You are not far from perfect because you are making perfect job Mr. Thank you so much. There is noting to say how I thank you.

 

[mumps]

My pleasure.

 

[Serdarrk]

My pleasure.

Again me with a problem. I disturb you for the last time. Now I need to take rows according to names which are choosen by me. I tryed to explain on the file. Macro must be like; I will enter a name it will take this name's row and more 3 rows with it of all page. I don't know it is possible but I trust your superior knowledge.

https://www.dropbox.com/s/i3a7axbb1niir6k/Yeni Microsoft Office Excel Çalışma Sayfası.xlsx?dl=0

 

[mumps]

I'm sorry but I don't understand what you want to do. Maybe you could upload a file that contains 3 or 4 source sheets and another sheet that shows what your final result will look like. Can you explain in detail what you mean by

I will enter a name it will take this name's row and more 3 rows with it of all page

 

[Serdarrk]

In Sayfa1 there are names in every second columns and I need to choose some of them. But they dont sort regular. I tried to tell in the new file in Sayfa2.


https://www.dropbox.com/s/d6otpv5agvbtypj/example.xlsx?dl=0

 

[Serdarrk]

Also you can look at this file too. If its more easy for you I can do from this type of files.


https://www.dropbox.com/s/0uvmvqvg8gd5kpq/örnek.xls?dl=0

 

[Serdarrk]

I'm sorry but I don't understand what you want to do. Maybe you could upload a file that contains 3 or 4 source sheets and another sheet that shows what your final result will look like. Can you explain in detail what you mean by

Sorry but need changed. So dont mind about it more. Thank you for interest again.

 

[mumps]

My pleasure.

 

[Serdarrk]

My pleasure.

But also it doesn't mean You escaped from me.I am really sorry to disturb you. If you have more 5 minutes for me please check this file. I need to sort by name I tried to explain in Sayfa1. Because same name sometimes is in the 10th rows sometimes 11th or 12th. There are names in B columns and datas in Y columns. So I need to sort a name with its' file name(date) and datas from Y columns which is this names' data. Can you help me about it?

https://www.dropbox.com/s/79w9409hat1mg55/list.xls?dl=0

 

[mumps]

How will you decide which name to use? Do you want to be prompted for a name?