muliple value to one

[khushboo#]

Hi,

Have a sheet full of data only in first 2 row, all i required is inserting 2 spaces between them and copying B1 cell value to A2. So that data in 1st row will be of A1 and A2=B1 value.
Have a code which helped me to insert spaces b/w them.
But copying data is something i was doing manually, so any modification in code will be a great help.
Attached file for better clarity.

[Winon]

Hello khushboo#,

Have a code which helped me to insert spaces b/w them.

Please could you upload a sample Workbook with such Code, so that we can see what to do where?

Regards.

[khushboo#]

Hi,

I have attached file with code, code are given in different sheet, named as Code.
Attaching it again.

[Winon]

Hi khushboo#,

Thank you for the reply.

I have attached file with code, code are given in different sheet, named as Code.

Do you mean to say Formulas instead of Code, or do you have a Workbook with actual VBA Code, which, if true, we would need to see.

[khushboo#]

Hi,
It's not a formula it's VBA code.
You can see that in attachment.