Re macro to paste scenario data

Hi all,

I have some data to send from sheet4 to sheet1, I found a post yesterday with a code created by watersev, it works like a charm. Thank you!
I have a small problem: i want to take data until last empty row of data "group"
i attached a test file
I really appreciated any help!

john

hi john55,

is this the code?

Please Login or Register  to view this content.

hi Pike,
I'm so sorry for my late response, I was on duty...!
Thank you for your solution. is not really what i want, all I want is to have in sheet1 the rows coresp. to "a" only.
i.e for "a" in Sheet4 i have just 4 rows with data, those rows i wanna be displayed in Sheet1.
for "b" in Sheet4 i have just 20 rows with data those rows i wanna be displayed in Sheet1.
and so on
thx again n I appreciate your help
john

Try this

Please Login or Register  to view this content.