Copy range from string until reach another string

[lmcquade91]

Hi guys!

I am fairly new to coding and have been playing around, so am self taught.

I am having some trouble with the below.

I have a CSV file containing 14 days of roster data. I want to copy each day's data onto a new sheet.

I was thinking of using cells.find to look for the string "loc" as that separates each days data, but am not sure how to copy FROM that string UNTIL reaching next one.

if anyone can give me some code or help me out it would be greatly appreciated!! Thank you guys!

 

[HighAndWilder]

How quick?

I organise a running race through a local forest in September each year. 10k or 6k.

It raises some money for charity.

I would like to reinstate our local marathon.

 

[lmcquade91]

How quick?

I organise a running race through a local forest in September each year. 10k or 6k.

It raises some money for charity.

I would like to reinstate our local marathon.

Wow!! Which forest?

I have a knee injury so I was very slow today, 2h30, but normally do 2h10

Did Perth marathon last year in 4h45!

Yay for running and coding!

Lara

 

[HighAndWilder]

Wow!! Which forest?

I have a knee injury so I was very slow today, 2h30, but normally do 2h10

Did Perth marathon last year in 4h45!

Yay for running and coding!

Lara

A small forest in Dorset call Moreton forest.

It was very wet (see image) as climate change has been playing havoc over here and forest tracks don't drain well.

Don't overdo it with the knee, they can take ages to heal.

 

[lmcquade91]

A small forest in Dorset call Moreton forest.

It was very wet (see image) as climate change has been playing havoc over here and forest tracks don't drain well.

Don't overdo it with the knee, they can take ages to heal.

Wow that looks so beautiful!! I'll have to add it to my list.

Well we know all about climate change here, we have bush fires, floods and hurricanes! Mother nature is all powerful!

Have a wonderful day and thanks for all the help

I'm starting my Data Science and AI course on Monday and feel very prepared now! I'll be in touch if I need your wonderful brain again

Lara xx

 

[HighAndWilder]

Wow that looks so beautiful!! I'll have to add it to my list.

Well we know all about climate change here, we have bush fires, floods and hurricanes! Mother nature is all powerful!

Have a wonderful day and thanks for all the help

I'm starting my Data Science and AI course on Monday and feel very prepared now! I'll be in touch if I need your wonderful brain again

Lara xx

As someone who has worked in IT for many years, one must always assume that the data is not what it should be and work towards disproving ones assumption.

Good luck with the course.