|
copy and paste function
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 |
copy and paste function
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 & -- David Biddulph "mike3004" wrote in message ... 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 |
copy and paste function
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 -- Don Guillett Microsoft MVP Excel SalesAid Software "mike3004" wrote in message ... 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 |
copy and paste function
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 "mike3004" wrote: 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 |
copy and paste function
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 "mike3004" wrote in message ... 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 |
copy and paste function
I think Rick intended to say =G5&F7 instead of =G1&F7
-- David Biddulph "Rick Rothstein (MVP - VB)" wrote in message ... 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 "mike3004" wrote in message ... 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 |
copy and paste function
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 "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I think Rick intended to say =G5&F7 instead of =G1&F7 -- David Biddulph "Rick Rothstein (MVP - VB)" wrote in message ... 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 "mike3004" wrote in message ... 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 |
copy and paste function
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? "Rick Rothstein (MVP - VB)" wrote: 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 "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I think Rick intended to say =G5&F7 instead of =G1&F7 -- David Biddulph "Rick Rothstein (MVP - VB)" wrote in message ... 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 "mike3004" wrote in message ... 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 |
copy and paste function
Teethless mama
I try your addin fucntion , this is exactly done from my case. Thank you! Mike HK "Teethless mama" wrote: 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 "mike3004" wrote: 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 |
| All times are GMT +1. The time now is 05:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com