Hi Friends,
I have converted text file to excel file and having some field alignment problem. Here are they:
1) Data are from column A to column AO.
2) Data available in all fields of A.
3) Check all data from C to AO in all rows. If all fields are blank(ignore A & B), delete entire row.
4) Check value in field O, If empty, check next row field D. IF empty, check until field D has value.
5) Cut the data from field D to end of row (say upto AZ)and paste it in field O of point # 4.
(i.e., check values of O1,O2,O3..... If O15 is empty then check D16 and if it has value, cut D16:AZ16 and paste it in O15 and delete row16. Check until nth row)
6) continue until end of last row.(may be upto 10,000 rows)
Could anyone provide me a VBA code for the above steps?
Thanks in advance.
Bookmarks