• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Transfer Periods to New Sheet with Different Format via Vba


New Member

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.

Thanks in advance for kindest helps


Pete Wright

New Member

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.

Could you explain?
Kind regards