Export specific data

[vletm]

Did You skip # If there are new files then press [ Get Files ] ?
... or what did You?

 

[Lenche08]

Hello
Yes i make mistake. Then i try it again and start working perfectly.

 

[Lenche08]

Hello expert Vletm
Can I ask you something? is possible to make one more file? Some macro that-maybe the same you create you just modifying something
I got and idea what I also need sometimes
I need to put multiple files together and then for every file : the name of the sample, data and time, point number, temperarute,shear rate and viscosity.
See the example below. For this example I prepared 3 files of data. Sometimes I have more then 50 files.

 

[vletm]

Lenche08​

Many things are possible, but ...
... there are none that-maybe ... just modify something ... codes.
If Your new idea is like that xlsx-file then
isn't it basically import and collect needed columns.
... if those csv-file have same layout ... if.
Did You even try to do it Yourself?

 

[Lenche08]

No
I did not try it.
I dont know how to make that to became automaticly like you create it.

hmmm I am lost in strings?

 

[vletm]

Your #71 reply - Ok i will test it and look and learn how to do it.
Where do You need ... strings?

 

[Lenche08]

why mean ff? ff is becouse F column? you cay here any other letter?

 

[vletm]

Good .. You try.
ff is the last F-column row
ff > 10 verifies that lower rows will reset.

Here one sample ...

 

[Lenche08]

Hi
First of all thank you very much for your example.
In this example On first sheet (Init) I dont have the three butttons like I have on another example? that mean that I must create it no?

 

[vletm]

Lenche08​

Those could solve some cases ...

 

[Lenche08]

Hi
yes
I am doing the bottons

 

[Lenche08]

I see that you also create the buttons in the excel you attached post #85 (NewIdea001). Thank you.
Thank you very much for helping me all week with my problems.

PS: How many years are you already doing magic with Excel?