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. On 30 Тра, 13:04, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi George, > Can't quite understand your request. > "column F down untill we reach two empty cells in columns F and J" > But your sample data doesn't have 2 empty cells in both F and J. > Perhaps you could attach a sample workbook with a bit more data - say 20 rows. > Regards - Dave. > > > > > Date: Fri, 29 May 2009 05:07:32 -0700 > > Subject: $$Excel-Macros$$ parse Excel file > > From: use...@ccx-grads.org > > To: excel-macros@googlegroups.com > > > Dear group members, > > > I have got .xls file where two columns (F and J) must be parsed. > > Columns look like this: > > > F J > > aaa bbb > > (empty) ccc > > (empty) ddd > > (empty) (empty) > > fff ggg > > (empty) rrr > > (empty) vvv > > (empty) (empty) > > > So, I need to go through these columns and copy data to other sheet: > > column J - "as is" > > column F - all but empty cells; copy and paste the same data from > > column F down untill we reach two empty cells in columns F and J; > > after that we copy and paste the next not empty data from column F. > > > I have to parse 23000 rows. > > > Help me please, I'm new to VBA. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
