Hello,
I'm new here and I'm must confess I'm ZERO in VBA. But I like the challenge to learn for some more.
I need to create a table (table 1) from another table (table 2 in different sheet) in which a specific row (row1) from table 1 will be copied and pasted to table 2 a number of times as appearing in specific cell in row 1 from table 1.
To be more specific:
Table 1 is a tasks table in which each task get a recurrence (weekly, monthly etc)- in specific cell I have calculated the frequency based on start and end date.
I'd like the script to automatically copy each row from table 1 (see example below) and paste it to table 2 as much as appears in the frequency cell (in the example below=9 times), and that the due date will update per frequency type (here weekly so it 'll add 7 days each row)
TASK ID TASK ASSIGNED TO START DATE END DATE DUE DATE FREQUENCY TYPE Frequency count
1 Laundry David 6/11/2018 8/11/2018 6/18/2018 WEEKLY 9
Hope it's not that complicated...
thanks much in advance!
Michele
I'm new here and I'm must confess I'm ZERO in VBA. But I like the challenge to learn for some more.
I need to create a table (table 1) from another table (table 2 in different sheet) in which a specific row (row1) from table 1 will be copied and pasted to table 2 a number of times as appearing in specific cell in row 1 from table 1.
To be more specific:
Table 1 is a tasks table in which each task get a recurrence (weekly, monthly etc)- in specific cell I have calculated the frequency based on start and end date.
I'd like the script to automatically copy each row from table 1 (see example below) and paste it to table 2 as much as appears in the frequency cell (in the example below=9 times), and that the due date will update per frequency type (here weekly so it 'll add 7 days each row)
TASK ID TASK ASSIGNED TO START DATE END DATE DUE DATE FREQUENCY TYPE Frequency count
1 Laundry David 6/11/2018 8/11/2018 6/18/2018 WEEKLY 9
Hope it's not that complicated...
thanks much in advance!
Michele
