Copy and paste (values) to another sheet based on condition

Hi, I have worksheet1 where there is a data.
I have a click button where only populated cells are copied and pasted to next sheet, however based on certain value of cells.
That means if value condition is not met, then it will not copy the cells.
While pasting it will paste with condition of next empty cells in a range.

Sample is attached.
Hope to get some help.
Thanks

Maybe:

Please Login or Register  to view this content.

Pl paste the formula in A2 of Sheet2 and press Ctrl+Shift+Enter keys together.Then drag the formula across.

Please Login or Register  to view this content.

As an option, there is a button on sheet1.

Hi,
Kvsrinivasmurthy, AB33 and John H Davis.

What shall i say. All the solutions work perfectly.
Thank you very very very much.
All solutions have their unique utility and output.

The formula works fine but since I have too many for mule in some other cells , it may not be possible to incorporate it.

Solution by John works great , but if I run it twice , it copies data again and pastes it below the existing one.

Solution by AB33 seems the best suited one for this issue. Every time I press button, it ignores what has been copied last time and does it again freshly.
Therefore I will adapt solution be AB33.
Once well done to everyone.
I still have one more question on this and after that I will close it as solved.
I have clicked * for everyone to express my gratitude.

Well done again.
Thanks
Regards

Hi AB33,
Apology that I could not come back so soon.
I was trying to learn your amazing code and try to understand it.
Then I wanted to modify it, but I have failed drastically. But I have not given up.
I have attached same file now ( with a difference) and need your BIG HELP to get this done so that my learning will get a big boost.
I am closing the thread as it has solved the initial issue, however I am sure that you will help me to modify your Great code.
Thanks again
Regards

My Greatest regards to kvsrinivasamurthy & JOHN H. DAVIS
Your solution also were amazing, however my current learning need I have chosen AB33 first followed by great help from John.
I sincerely hope for the best.
kind regards

Try the attached.

Hi AB33,
Great help again.
My words will ever fall short to thank you.
Kind regards