I have got following data in excel. I need to copy 1st number in given row for e.g. 122532 should be copied against 100 for 4 times & similar way 321654 should be get copied against 200 for 3 time like way. ( Problem is that I'm not sure how many times 100 or 200 nos. comes )
kindly suggest me macro to run the same for very large data 122532 100 100 100 100 321654 200 200 200 654987 300 300 300 300 300 300 987654 100 100 789654 300 300 300 300 300 300 300 300 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
