• 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

    Hui...

  • 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

zrs

New Member
Hi,

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
 

Attachments

  • PERIODS.xlsx
    12.8 KB · Views: 10
Hi,

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
 
Back
Top