$$Excel-Macros$$ Re: parse Excel file

2009-05-31 Thread George
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

$$Excel-Macros$$ Re: parse Excel file

2009-05-30 Thread Dave Bonallack
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