Populate range of values from sheet 1 to sheet 2

[refusedzero]

Hello everybody,

It's my first post. I've just started my journey with VBA. I'm creating my first macro and i cannot resolve one issue.

I have source data sheet like this one:
source_sht1.PNG

I want to populate the range of the same data from Column A to the separate sheet2. For example: From Cloumn A within the same "AAA' values (range: A4:A7) i want to populate all data from Column B to E (highlighted in orange). The second sheet should look like this:
Sheet2.PNG

The macros should end when Column A value = empty

Please help me with this so i could finish my macro .

Thank you in advance.

[patel45]

attach please a sample xlsm file, no images

[refusedzero]

@patel45
I'm so sorry, i'm new here.
Please find attached xlsm file: Populate.xlsm

[HaHoBe]

Hi, refusedzero,

maybe try it like this:

Please Login or Register  to view this content.

Ciao,
Holger

[refusedzero]

Thank you HaHoBe. I will test your code, but i've just found this one which works perfectly for me.:

Please Login or Register  to view this content.

I need to tuning it a little. I want to max. 20 row per sheet, so when the selected cell rows is > 20 i want to create another sheet for the rest of the values. Any hint ?? :>