amazon_devil
New Member
- Joined
- Jul 30, 2018
- Messages
- 4
I am trying to figure out a tidy way to write the following scenario.
Worksheet A
Has a list that, from project to project will vary in the number of rows in it.
Example of information in Worksheet A. Data to be used in Calendar Month column.
<tbody>
</tbody>
Worksheet B
Tracking sheet that is using the list from Worksheet A, to populate the titles of columns going across the sheet.
I want the script to use the value in each of the rows (3 times each before moving to the next row) from Worksheet A, across the top of worksheet B to create the titles for a table.
Worksheet A
Has a list that, from project to project will vary in the number of rows in it.
Example of information in Worksheet A. Data to be used in Calendar Month column.
| Calendar Month | Start Date | End Date |
| Jul-18 | 01/07/2018 | 31/07/2018 |
| Aug-18 | 01/08/2018 | 31/08/2018 |
| Sep-18 | 01/09/2018 | 30/09/2018 |
| Oct-18 | 01/10/2018 | 31/10/2018 |
| Nov-18 | 01/11/2018 | 30/11/2018 |
| Dec-18 | 01/12/2018 | 31/12/2018 |
<tbody>
</tbody>
Worksheet B
Tracking sheet that is using the list from Worksheet A, to populate the titles of columns going across the sheet.
I want the script to use the value in each of the rows (3 times each before moving to the next row) from Worksheet A, across the top of worksheet B to create the titles for a table.
So what does worksheet B look like?
