Copy range from worksheet to new worksheet and rename new worksheet

[Phil Smith]

Hi all.

I have a Word document which has been saved as a .txt document and then been imported into one worksheet in Excel as a table.

What I would like to do is as follows:

From the last row of data on worksheet "Jobs", variable lastrow, find the first row before it containing "London", variable jobstart.

Cut and paste range cells (jobstart,1),cells (lastrow,6) to new worksheet.

Rename new worksheet as the value in cell (3,3) on the new worksheet.

Repeat and insert new worksheet before the previously newly created worksheet.

Loop through until renamed sheet="600"

Thanks in advance.

Phil

 

[Phil Smith]

As I have had no replies to my original request, I'm just wondering if I made a hash of the explanation.

So... here is another attempt.

Find last row on Worksheets("Jobs") containing "End" & assign row number to variable lastendrow

Find last row on Worksheets("Jobs") containing "Start" & assign row number to variable laststartrow

Create new worksheet after Worksheet("Jobs")

Cut range (laststartrow,1),(lastendrow,6) from Worksheet("Jobs")

Paste to cells(1,1) on new worksheet

Rename new worksheet from value of cell(3,3) on new worksheet

Delete rows that were just cut from Worksheet("Jobs")

If laststartrow>2 then repeat

Is that any clearer? I know what I want to do, I'm just not always great at the explanation! Sorry!