VBA copy value to specific columns

[Excl3454]

hello everyone.
Can you please let me know if it is possible to copy some cells to specific columns in same row?
like this example if i enter any value from 1-15 into A:F, copy them in the same row under same numbers?
Many thanks
screenshot.5841.jpg

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a number in A:F and press the RETURN key.

Please Login or Register  to view this content.

[torachan]

Similar solution to @Mumps
Input range limited to A2:F5

Please Login or Register  to view this content.

[Excl3454]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a number in A:F and press the RETURN key.

Please Login or Register  to view this content.

Thank you so much for quick solution wish you all best

[Excl3454]

Similar solution to @Mumps
Input range limited to A2:F5

Please Login or Register  to view this content.

Thank you so much very nice of you

[Excl3454]

do you know if copies can be deleted if it is deleted from A:F?
Thnaks again

[Mumps1]

You are very welcome.

[torachan]

Follow up of PM from OP.
Alternative for group of data.
Copy range "A20:F23" - paste to range "A2:F5" - press green button - block splits and transfers.
small macro in sheet module on green button.
hope this is what you wanted.
torachan