help to copy data from one sheet to another sheet with the condition

[thufpt]

I have a link google sheet

docs.google.com/spreadsheets/d/1lymFeUyL2Wr4CWXuOVwPm4YM7KQew4eF_HDr-EAy2Kk/edit#gid=0

including sheet data and sheet abc, now the data needs to handle as commented below
1) at 10 am every morning following the time of the computer, the data in the sheet abc(columns A and B) will be copied to fill sheet data(columns Z and Y)
in the direction from right to left and fill in the date fill, update once time for per day
2) if after 10 am I still want to update can click on the button "copy" and then it will handle the same as the point (1)
3) in case of sheet abc doesn't have enough columns to fill then show alert (don't have the column to fill)

actually, I handled it manually but many times I forgot to copy it at 10 am and can't go back because the data will be changed continuously
so the purpose of this is to get that data right at 10 am and save it in sheet abc

[Marc L]

As Google sheets is not compatible with this Excel VBA forum section …

[thufpt]

As Google sheets is not compatible with this Excel VBA forum section …

So can you show which forum can help me

[Marc L]

As this forum is named 'Excel forum' so obviously not the place for a specific Google sheets question …

[JohnTopley]

See

Forum

For Other Platforms(Mac, Google Docs, Mobile OS etc)

[thufpt]

at first time, I thought it is also Excel and it is the same as Microsoft Excel but is not, ok I just posted to another forum, thank you for your support