EXCELL HELP PLEASE

am not a macro expert at all but i think its the only way to do this kind of job, someone might tell you if your lucky.

First you could introduce a column 1 2 3 4 etc so you can always revert to the original order of data, then use SORT function and copy and paste into the required coumns, i'd imagine it's do-able

Only one ' L ' - hope this helps.

If it's not too large a file you can send it to me by mail and i'll have a go

sorry i didnt explain it too wel

i really wanted this doing..

Been yonks since ive used this so cant remember a thing...

Say you have data in the form

1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
5
MR E Smith
024 555555
105 ANY ADDRESS, Coventry, West Midlands, POSTCODE
6
MR F Smith
024 666666
106 ANY ADDRESS, Coventry, West Midlands, POSTCODE

all this appears in A1:A24

The list in column A is lot lot bigger than this but using 6 contacts as an example

[u]QUESTION[/u]

how do i get it so it appears on a new sheet as follows

A1:B1:C1:D1 would be 1,MR A Smith,024 111111,101 ANY ADDRESS, Coventry, West Midlands, POSTCODE

A2:B2:C2:D2 would be 2,MR B Smith,024 222222,102 ANY ADDRESS, Coventry, West Midlands, POSTCODE

ETC ETC



not explained it too well but hope its clear enough...

THANKS IN ADVANCE , SHERRIFF

ps star fish... have you got an old email address i can send it to for you.. thanks again

simonsimon141 at hot mail . com

sent..thanks

hope that does the trick

thats great but just sent you another e mail to see how you did it.. :)

Sheriff, in my example your data is in Sheet 1 and your new sheet is sheet 2.

Sheet2...

A1 = 1
B1 = 2
C1 = 3
D1 = 4

A2 =INDEX(Sheet1!$A:$A,MATCH(Sheet2!A1,Sheet1!$A:$A,0)+1)
A3 =INDEX(Sheet1!$A:$A,MATCH(Sheet2!A2,Sheet1!$A:$A,0)+1)
A4 =INDEX(Sheet1!$A:$A,MATCH(Sheet2!A3,Sheet1!$A:$A,0)+1)

Then just drag A2:A4 formula over to columns B C D

nearly got it but still cant quite crack it... grrrr

I replied, both my way and Mr Nibs will do it, what's the sticking point?

sorry m8..just seen your mail.. thanks again...

Np :-)

little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheet

if you have

a1=Sheet6!A1
a2=Sheet6!A6
a3=Sheet6!A11

and i want to carry on this series downwards eg in a4 i would have

=Sheet6!A16 and then A21 etc etc..

how do i drag the formulas downwards or what function do i use in order to maintain the series

my head fried at min

anyone

Sheriff,

Cell A2 in sheet 7

=INDEX(Sheet6!A:A,MATCH(A1,Sheet6!A:A,0)+5,1)

Then drag down

Just make sure A1 in sheet 7 is =Sheet6!A1