My excel file is attached. How can the periods in Sheet1 can be transferred to Sheet2 with vba as in that format? Details are explained in excel file as well.
I am sorry, but even after checking the Excel file I don't understand your question.
Did you know that you can also record a macro (VBA code):
Just press the record button, do whatever you want to do within the Excel file, stop recording, save as Macro.
Then you can repeat that task (eg.: formatting) with just a click.