Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting rows | Excel Worksheet Functions | |||
Sorting Rows | Excel Worksheet Functions | |||
[sorting rows] | Excel Worksheet Functions | |||
sorting rows | Excel Worksheet Functions | |||
Sorting Rows in VBA | Excel Programming |