Add rows to a table and add data automatically

Hi There,

I am using this code to add 15 rows each time to a table.

Please Login or Register  to view this content.

What I would like to do now is to have it automatically add the numbers 1 to 15 in column A for each row added.

Ask me for a date, start time and end time and add this to each row in column E , G and H

1				01/01/2023	11:00	20:00
2				01/01/2023	11:00	20:00
3				01/01/2023	11:00	20:00

All the way down the 15 rows.

Thank you.

try

Please Login or Register  to view this content.

Hi k1dr0ck

Your code works fine

Is there a way to change the date format so it shows Tue 10 Jan 2023 and not 10/01/2023

Thanks

Please Login or Register  to view this content.