Sorting Rows
I am still struggling with this.
This below is how it set out in Excel. I am wanting to take the information
which in the first set of data is in Cell A4 and move up 3 rows and paste in
to what would be in Column I but for this case it would be Cell I1. This
would carry on down the page till I reach around row 2000, also the problem
is that it may not be 2 blank rows between address and carcass row. This is
changeable
(Cell A1)4195-0000 (Cell C1)10046000932(Cell D1)10 The Street, Any Town,
Big City, PC1 2PC (Cell G1)08(Cell H1)11/04/2005
(Cell A4)Carcass CARCASS - Fire Open FLAVEL WELCOME G/F - UnitHtr
R/S BAXIBRAZILIA2 SLIMLINE - UnitHtr R/S MAXOL MONTANA 1500
I hope this is easier to explain what I am doing. I am taring my hair out
with it now :-)
If its easier I could email a example file for you to look at. please let me
know.
Thanks,
Jez
|