I am in the process of learning to drive Google Sheets, as I learned my Job Database file I have been developing will not work in Office 365 online or mobile devices due to VBA not being supported.
I want to learn how to replicate what I have already created in Excel, sheet attached, in Google Sheets. Never used Google Sheets before and not familiar with GAS.
The first item I would like to tackle is how to automatically copy down a range # of times based on a value in another cells. So in the Recurring Job Entry Sheet TEST!, copy range A6:X6 down number of times indicated in cell O2.
Here is the code I am using in Excel.
Sub CopyOccurrences()
'
' Macro1 Macro
'
'
Sheets("Recurring Job Entry Sheet TESTI").Select
[A6:S6].Copy [A7].Resize([O1].Value2)
End Sub
Thank you.
Bookmarks