Need help in organising data

[robo9]

I am totally fresher in macros. Hope I will find help from this platform. I want to take out a fix percentage of rows from a worksheet for reporting purpose. Eg. If I have a worksheet of 20 rows & I need 75% of rows (i.e. 15 rows) out of it. Also, if the result of 75% is not a complete number (eg 15.2 rows), it should roundoff to 16.

[Killer42]

I am totally fresher in macros. Hope I will find help from this platform. I want to take out a fix percentage of rows from a worksheet for reporting purpose. Eg. If I have a worksheet of 20 rows & I need 75% of rows (i.e. 15 rows) out of it. Also, if the result of 75% is not a complete number (eg 15.2 rows), it should roundoff to 16.

I believe the expression is "round up" to 16.

Using your example, do you want to pick out 15 rows at random, or just take the first 15?

[robo9]

I believe the expression is "round up" to 16.

Using your example, do you want to pick out 15 rows at random, or just take the first 15?

Thanks for replying. Let me clarify-

I need to pick 75% of rows..it can be random or first rows. Eg. I have following data in a worksheet in 4 rows (4 rows is not fixed, it can be any number):

111111 wqerweqwrwwerqwr abdcdfd COMPLETE
123455 zxcvzxvxzvxvxcvxzv asdfsafs Not done
352114 sfasfsfdsfsadfsafasf asdffdfd In Progress
555555 asdfsafsafasfsafsfsf asdfsaff COMPLETE

I need to pick 75% of 4 rows & delete the rest. So, I will need any 3 rows randomly out of 4 & delete 4th.

However, if there were 5 rows, the 75% of that will come to 3.75 which I need the macro should roundup to 4 rows. I will eagerly await the response..!!