Copy morning and evening data and pasting in another sheet

Thank you so much for the reply.

I want the data to be copied in the format as it is given in the attached file.

Sheet 1 will contain blank cells in between the numbers like this and this blank cells will contain formula in sheet 2. The data will change everyday in morning and evening in sheet1in the same row. SO the macro will be run twice, once in the morning and again in the evening. And in sheet 2 it will copy by seeing today's date and recognising it as morning or evening.

Hope I am clear in what I have said.

Thank you again for your prompt reply.

Nilan