ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sorting Rows (https://www.excelbanter.com/excel-programming/357806-sorting-rows.html)

Jez[_7_]

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



All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com