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 wqerweqwrwwerqw r abdcdfd COMPLETE
123455 zxcvzxvxzvxvxcv xzv asdfsafs Not done
352114 sfasfsfdsfsadfs afasf asdffdfd In Progress
555555 asdfsafsafasfsa fsfsf asdfsaff COMPLETE
I need to pick...
robo9
Last Activity: Mar 8 '07, 08:42 PM
Joined: Jan 30 '07
Location:
-
Need help in organising data
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.
No activity results to display
Leave a comment: