I want to replicate the following cells:
A10 to J133 into A140
Please let me know how to do it.
Thank you.
I want to replicate the following cells:
A10 to J133 into A140
Please let me know how to do it.
Thank you.
Hi rocasan,
It it one time exercise, copy - paste will do
Else you can record a macro to do this everytime ..
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
EXCEL 2010
Thank you for your reply.
I tried to use COPY/PASTE but does not work.
I do not know how to use MACROS.
Thank you.
It may be a formula cell use Alt+E+S+V to paste it as values.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try this in K10
=A10&B10&C10&D10&E10&F10&G10&H10&I10&J10&K11
drag it till end J133
Note it doesn't pick the more than 1020 Length in a cell
try this if it gets your work some easy!!
Amit Kumar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks