Hi everyone,
I know there are some similar posts out there, but I’m terrible with understanding macros. Could someone tell me a macro for the following?
Here’s an example data set:
<tbody>
</tbody>
I would like the macro to rearrange the data in a new spreadsheet as follows:
<tbody>
</tbody>
I’m looking for a good format for:
-individual groups to record attendance, as well as, weekly topics
-a macro that convert the attendance of all of the groups into vertical data that can then be imported in Access
I intentionally left multiple spaces between the last entry and the topic area because each group will vary in the number of participants. I know that this data could technically go above the date information if that would be easier. On average each group will have 8-12 participants and there will be enough dates for a full school year of weekly or bi-weekly meetings.
Thank you if you can make this work!
I know there are some similar posts out there, but I’m terrible with understanding macros. Could someone tell me a macro for the following?
Here’s an example data set:
A | B | C | D | E | F | G | H | |
1 | | Date | Status | | | | | |
2 | ID | First | Last | Service Group | 10/9/2015 | 10/14/2015 | 10/21/2015 | 10/28/2015 |
3 | 11111 | A | L | Senior Citizens | Present | Present | Present | Absent |
4 | 22222 | D | A | Senior Citizens | Present | Present | Present | Present |
5 | 33333 | A | A | Senior Citizens | Present | Present | Present | Present |
6 | 44444 | H | P | Senior Citizens | Present | Absent | Present | Absent |
23 | ||||||||
24 | ||||||||
25 | ||||||||
26 | ||||||||
27 | ||||||||
28 | ||||||||
29 | Topic | getting to know each other | played game, did survey | discussed prices in the 30s-70s & 2015, did survey | made posters of 30s-2015 |
<tbody>
</tbody>
I would like the macro to rearrange the data in a new spreadsheet as follows:
| A | B | C | D | E | F | G |
1 | Date | ID | First | Last | Service Group | Status | Topic |
2 | 10/9/2015 | 11111 | A | L | Senior Citizens | Present | getting to know each other |
3 | 10/9/2015 | 22222 | D | A | Senior Citizens | Present | getting to know each other |
4 | 10/9/2015 | 33333 | A | A | Senior Citizens | Present | getting to know each other |
5 | 10/9/2015 | 44444 | H | P | Senior Citizens | Present | getting to know each other |
6 | 10/14/2015 | 11111 | A | L | Senior Citizens | Present | played game, did survey |
7 | 10/14/2015 | 22222 | D | A | Senior Citizens | Present | played game, did survey |
8 | 10/14/2015 | 33333 | A | A | Senior Citizens | Present | played game, did survey |
9 | 10/14/2015 | 44444 | H | P | Senior Citizens | Absent | played game, did survey |
<tbody>
</tbody>
I’m looking for a good format for:
-individual groups to record attendance, as well as, weekly topics
-a macro that convert the attendance of all of the groups into vertical data that can then be imported in Access
I intentionally left multiple spaces between the last entry and the topic area because each group will vary in the number of participants. I know that this data could technically go above the date information if that would be easier. On average each group will have 8-12 participants and there will be enough dates for a full school year of weekly or bi-weekly meetings.
Thank you if you can make this work!