Automation.

Hi,

I'm not sure if this is possible to do.

Is it possible to have a row of cells each with a number in it, on a specific day and time the numbers automatically drop down to the next cell and the bottom number goes up to the top cell, ie. they automatically go down then up and keep repeating.

You'll need to change pianoRoll to specify the sheet name and range involved.
You also need to set the day and time in setTime.
If you want this to be done once a day, uncomment the last line of pianoRoll

Please Login or Register  to view this content.

That's great thanks Mike

Mike,
Will the code in the set time section make it run the same time each week.
Thanks