How to split numbers to specific name and total and split
NAME TOTAL SPLIT SERIAL SERIAL FROM TO
X 200 2 A 1000 1999
Y 100 1 B 2000 2499
Z 400 4 C 3000 3499
D 5000 5999
I WANT RESULT RANDOM SELECT
NAME SERIAL FROM TO
X A 1050 1099
X C 3400 3449
Y C 3100 3149
Z A 1100 1149
Z B 2250 2299
Z C 3150 3200
Z D 5700 5749
sample image
Hi, welcome to the forum
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
HOW TO.xls excel file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks