Hi George, Have a look at the attached to see if it does what you need. The macro puts the new data onto sheet 2, but it could just as easily modify the sheet the data is on (sheet 1). Regards - Dave.
> Hi Dave, > > I'll try to describe it better. > > I have columns like > > F J > data1 data2 > (empty) data3 > (empty) data4 > (empty) (empty) > data5 data6 > (empty) data7 > (empty) data8 > (empty) data9 > (empty) (empty) > > My result must look like: > > F J > data1 data2 > data1 data3 > data1 data4 > (empty) (empty) > data5 data6 > data5 data7 > data5 data8 > data5 data9 > (empty) (empty) > > I hope it is better to understand now... > I have to parse 23000 rows. _________________________________________________________________ Want to stay on top of your life online? Find out how with Windows Live! http://windowslive.ninemsn.com.au/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Book4.xls
Description: MS-Excel spreadsheet
