Hi, I did trawl through a few hundred similar topics but could not find my answer.. here goes;
I am using Excel 2007 on a win7 machine and I am manipulating data I cut and paste into a spreadsheet.
I need to check the number of empty rows after the character "Kg" or "L" or "CL" that is preceeded by a number.. so it could be "1 Kg" or 0,5 Kg" or "0,5 L" but there seems to always be a space before the Kg or L if that helps.
I need there to be 6 empty rows between the Kg and the cell that contains a price.. for example "3.24€"
All my data is in Col "A"
example data:
A1:item description
A2: empty row
A3:brand name
A4: empty row
A5: empty row
A6:1 Kg
what i need it to be is:
A1:item description
A2: empty row
A3:brand name
A4: empty row
A5: empty row
A6: empty row
A7: empty row
A8: empty row
A9: empty row
A6:1 Kg
I might add that the number of rows above the Kg or L or Cl is not constant so I couldnt attack the problem by deleting the empty rows and simply adding the desired number of rows.
I also add that the number of rows after the weight measure might be 2 or 3 or 4, etc but as I said I need it to be six due to some pre written vba I have.
what I am trying to do is align horizontaly that data and it seems that the constant is the weight part of my data.
thanks in advance
Bookmarks