copy a block of cells that can vary in rows and columns

Dear all,

I have attached a workbook as an example.
From the sheet1 I need to copy a block of information. Some times the information has more rows or more columns. I would need to copy the last cell in a row and the last cell in a column to form a block that I can paste in another workbook.
I can get the last used cell in a row and in a column, but can't figure out how to select the whole block of cells.
Great would also be if there was a text in a cell (column B) and then start copying from there.
Can one help out pleases?

Greetings,
megatronixs

How's this for you?

Please Login or Register  to view this content.

Hi TMS,

Thank you for a great macro. I just added a new sheet that will be more clear with what should be the end result.

As you can see there is the first sheet that has some data. There are a few different blocks in it. What really needs to be done is that it should cut out the blocks and put them on a different sheet. Then they all should have the same title rows "My name....." "Text 1 Text2: Dummy text" and the last part of the "Note:......"
(I kept the blocks in a color so you know what I mean with the blocks)
in this case, it would take the second block, cut it out and put it on the second sheet with the title rows, then will go and cut out the third block and put it in the third sheet. All this until there are no more blocks and they all got their own sheet.
I guess this is a difficult one, but can this be done?

greetings,
megatronixs

Dear all,

thank you for your great and quick answers. I hope I can find a working solution that will just do what I need and this also can be a help for others hopping to find similar things.

Really, this is a great excel forum ;-)