Excel VBA D1,D2,D3 to D1-D3
Hi,
Im trying to create a code that converts:
C1001,C1009,C1034,C1117,C1145,C5048,C5056,C6205,C6206,C6207,C6229,C6230,C6231
TO
C1001, C1009, C1034, C1117, C1145, C5048, C5056, C6205-C6207, C6229-C6231
For example.
So when the nummers add up put a - instead of summing it all up with ,
so 1,2,3,4,5,6,7,8,9,10 would be 1-10
It's suppossed to do a complete column on a sheet
Can you guys help me out a little?
Hi,
give us a example workbook so we get a better picture of what you mean.
Are the numbers always in order with gabs in it?
and where do you want the output?
Grtz
Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
If you have been helped, maybe you could click the *
Attached some example data.
The output can go into the same column.
UDF
C2:
=GetList(B2)
Then copy down.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks