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