copy and paste function

[mike3004]

When I copy one column to next column, the function should be auto changed to:
=F5&""&F6
=F6&""&F7
=F7&""&F8
....

But I want to change like these:
=F4&""&F5
=F4&""&F5&""&F6
=F4&""&F5&""&F6&""&F7
=F4&""&F5&""&F6&""&F7&""&F8
....
How should we set ? Or could not ?

Thanks a lot!

Mike HK

 

[David Biddulph]

I can't answer your question, but I wonder why you said =F5&""&F6 rather
than just =F5&F6 (and similarly in your other expressions)?
If you had said =F5&" "&F6 (with a space between the quotes) then I could
have understood it, but without the space the &""& seems equivalent to &

 

[Don Guillett]

F G
a
b a b
c a b c
d a b c d
e a b c d e

Is this what you want?
Sub accumulate()
mystr = Cells(4, "f")
For i = 5 To Cells(Rows.Count, "f").End(xlUp).Row
mystr = mystr & " " & Cells(i, "f")
Cells(i, "g") = mystr
Next i
End Sub

 

[Teethless mama]

Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/english/

....then try this formula

=MCONCAT(IF(F5<>"",$F$5:F5,""))

copy down as far as needed

 

[Rick Rothstein \(MVP - VB\)]

If I understand your question correctly, consider this. Let's say your first
formula (=F5&F6) is in G5, then put this in G6 and copy down...

=G1&F7

Rick

 

[David Biddulph]

I think Rick intended to say =G5&F7 instead of =G1&F7

 

[Rick Rothstein \(MVP - VB\)]

I just have to see if I can trade my fingers in for a new set... they never
seem to type I am thinking anymore.<g>

Thanks for catching that David.

Rick

 

[mike3004]

Thanks all warm reply!
Let me explain my requires, I want to access text from F4 to F100 indeed:
such as
F4 I
F5 feel
F6 so
F7 happy
....
anyone have idea?

 

[mike3004]

Teethless mama

I try your addin fucntion , this is exactly done from my case.
Thank you!

Mike HK

 

[Don Guillett]

Did you look at my macro solution? I, for one, am STILL not sure what you
want. Send a workbook to my address below if desired along with a complete
explanation of what you DO want and an example.