hi I'm new here but hoping someone can help, I'm no good with scripts at all, just need some help, what i want to do is copy and repeat cells a,b,c,d,e, based on info in cells F and G using the scripts.
in cells d and e are dates and they need to increase by value in cell F and keep repeating based on value in G, i have made a sample sheet, on the sheet input is the data, and on sheet output it shows the results i would need, but all info need to stay on the input sheet not a different sheet. hope u can understand what i mean when u see the sample sheet. on the sheet in cell f it says weeks, this would be better in days then weeks, thanks.
https://docs.google.com/spreadsheets...it?usp=sharing
What I am trying to do is use Google sheets, input the data and it will automatically add events to google calendar, but some events will be reoccurring so need to sort that bit, thanks for the help.
Thanks Ditch
in cells d and e are dates and they need to increase by value in cell F and keep repeating based on value in G, i have made a sample sheet, on the sheet input is the data, and on sheet output it shows the results i would need, but all info need to stay on the input sheet not a different sheet. hope u can understand what i mean when u see the sample sheet. on the sheet in cell f it says weeks, this would be better in days then weeks, thanks.
https://docs.google.com/spreadsheets...it?usp=sharing
What I am trying to do is use Google sheets, input the data and it will automatically add events to google calendar, but some events will be reoccurring so need to sort that bit, thanks for the help.
Thanks Ditch