Split number into numbers!
how to split a number into multiple smaller numbers?
For example, there are 17 apples, 22 oranges and 14 peaches to be store into basket.
Each basket can store 10 apples, so...
basket1 = 10 apples
basket2 = 7 apples and 3 oranges
basket3 = 10 oranges
basket4 = 9 oranges and 1 peach
basket5 = 10 peaches
basket6 = 3 peaches
How can I do this with vba?..Anyone please help me up
Last edited by sianjialin; 11-20-2013 at 09:01 PM.
Can you post a workbook with a before and after example of what the data looks like?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
@sianjialin,
Here you go, Hope this helps.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
@sianjialin,
Ignore the previous one, this is the updated version with user defined basket size.
Hope this helps.
@xlbiznes
Nice, it work perfectly!!!
Really appreciated, I learn so much in all these vb codes, thanks you so much!
I need some upgrade version, because I provide the insufficient information for you guys.
I go test it first and see whether I can solve it myself or not?..for my poor vba skill, i think i can't!
I will be back later, hope you guys can help me again.
@sianjialin ,
You are welcome.
Glad,that i could help. If you are satisfied with the solution , please mark this thread as solved.
How to mark it?
Sorry about that, I'm new in vba and this forum.
@sianjialin,
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.
done, thanks you so much xlbiznes, I post another thread for additional function, go and take a look there~
hello, for the same problem how to change the vba to cater for different basket qty?
for example - instead of every basket 10 fruits,
basket 1 - 4 fruits
basket 2 - 6 fruits
basket 3 - 8 fruits
help~~
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks