Hey Everyone,
A school I am helping out at is going to use an "Attendance" app... it is an iOS app that helps you collect attendance on the students. It allows you to export the data in a csv. I need to have this data Appended to a master sheet each time. There are 15 different classrooms, so there will be a minimum of 15 csv in a folder everyday.
This is what the csv would look like:
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #000000; color: #FFF; font-weight: bold;}
</STYLE>
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Tahoma, Geneva, sans-serif; font-size: 14px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<TABLE class=tableizer-table>
<TBODY><TR class=tableizer-firstrow><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH></TR><TR><TD>1</TD><TD>TEAM A</TD><TD>8/6/2011</TD><TD> </TD></TR><TR><TD>2</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>3</TD><TD>Jane Barker</TD><TD>Present</TD><TD>10:29:07 AM</TD></TR><TR><TD>4</TD><TD>Mike Ruffle</TD><TD>Abscent</TD><TD>Death in the family</TD></TR><TR><TD>5</TD><TD>David Gilberson</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>6</TD><TD>June Shine</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>7</TD><TD>Allison Smith</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>8</TD><TD>Maria Thomas</TD><TD>Present</TD><TD>10:29:11 AM</TD></TR><TR><TD>9</TD><TD>Adam Fredricks</TD><TD>Present</TD><TD>10:29:13 AM</TD></TR><TR><TD>10</TD><TD>Brian Johnson</TD><TD>late</TD><TD>arrive 11am</TD></TR>
</TABLE>
I would need help with a macro that pulls in these csvs and:
1.) Looks at the students names (Column A), and addsthe information from columns B & C to the master sheet.
2.) It would ideally need to match up the info from B & C to the header too... so all of the 8/5 attendance data meets up with the other classroom Csvs that would be coming in....
Output would look something like this.... This has extra people thrown in to represent data being pulled in from multiple csvs with other students.
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Tahoma, Geneva, sans-serif; font-size: 14px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<TABLE class=tableizer-table>
<TBODY><TR class=tableizer-firstrow><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH></TR><TR><TD>1</TD><TD>Students</TD><TD>8/5/2011</TD><TD> </TD><TD>8/6/2011</TD><TD> </TD></TR><TR><TD>2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>3</TD><TD>Allana Anderson</TD><TD>Present</TD><TD>10:29:07 AM</TD><TD>Present</TD><TD>10:29:07 AM</TD></TR><TR><TD>4</TD><TD>Jane Barker</TD><TD>Present</TD><TD>10:29:07 AM</TD><TD>Present</TD><TD>10:29:07 AM</TD></TR><TR><TD>5</TD><TD>Mike Ruffle</TD><TD>Present</TD><TD>10:29:09 AM</TD><TD>Abscent</TD><TD>Death in family</TD></TR><TR><TD>6</TD><TD>David Gilberson</TD><TD>Excused</TD><TD>doctors Appt</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>7</TD><TD>Bella Nuance</TD><TD>Present</TD><TD>10:29:10 AM</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>8</TD><TD>June Shine</TD><TD>Late</TD><TD>in at 10:00am</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>9</TD><TD>Allison Smith</TD><TD>Present</TD><TD>10:29:10 AM</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>10</TD><TD>Maria Thomas </TD><TD>Present</TD><TD>10:29:11 AM</TD><TD>Present</TD><TD>10:29:11 AM</TD></TR><TR><TD>11</TD><TD>Jeff Daniels</TD><TD>Absent</TD><TD>abscent kids were sick</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>12</TD><TD>Bayley Hanson</TD><TD>Present</TD><TD>10:29:13 AM</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>13</TD><TD>Adam Fredricks</TD><TD>Present</TD><TD>10:29:13 AM</TD><TD>Present</TD><TD>10:29:13 AM</TD></TR><TR><TD>14</TD><TD>Sarah Sky</TD><TD>Present</TD><TD>10:29:14 AM</TD><TD>Present</TD><TD>10:29:14 AM</TD></TR><TR><TD>15</TD><TD>Brian Johnson</TD><TD>Present</TD><TD>10:29:14 AM</TD><TD>Late</TD><TD>arrive 11am</TD></TR><TR><TD>16</TD><TD>Ellie Dayson</TD><TD>Present</TD><TD>10:29:15 AM</TD><TD>Present</TD><TD>10:29:15 AM</TD></TR>
</TABLE>
A school I am helping out at is going to use an "Attendance" app... it is an iOS app that helps you collect attendance on the students. It allows you to export the data in a csv. I need to have this data Appended to a master sheet each time. There are 15 different classrooms, so there will be a minimum of 15 csv in a folder everyday.
This is what the csv would look like:
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #000000; color: #FFF; font-weight: bold;}
</STYLE>
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Tahoma, Geneva, sans-serif; font-size: 14px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<TABLE class=tableizer-table>
<TBODY><TR class=tableizer-firstrow><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH></TR><TR><TD>1</TD><TD>TEAM A</TD><TD>8/6/2011</TD><TD> </TD></TR><TR><TD>2</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>3</TD><TD>Jane Barker</TD><TD>Present</TD><TD>10:29:07 AM</TD></TR><TR><TD>4</TD><TD>Mike Ruffle</TD><TD>Abscent</TD><TD>Death in the family</TD></TR><TR><TD>5</TD><TD>David Gilberson</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>6</TD><TD>June Shine</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>7</TD><TD>Allison Smith</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>8</TD><TD>Maria Thomas</TD><TD>Present</TD><TD>10:29:11 AM</TD></TR><TR><TD>9</TD><TD>Adam Fredricks</TD><TD>Present</TD><TD>10:29:13 AM</TD></TR><TR><TD>10</TD><TD>Brian Johnson</TD><TD>late</TD><TD>arrive 11am</TD></TR>
</TABLE>
I would need help with a macro that pulls in these csvs and:
1.) Looks at the students names (Column A), and addsthe information from columns B & C to the master sheet.
2.) It would ideally need to match up the info from B & C to the header too... so all of the 8/5 attendance data meets up with the other classroom Csvs that would be coming in....
Output would look something like this.... This has extra people thrown in to represent data being pulled in from multiple csvs with other students.
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Tahoma, Geneva, sans-serif; font-size: 14px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<TABLE class=tableizer-table>
<TBODY><TR class=tableizer-firstrow><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH></TR><TR><TD>1</TD><TD>Students</TD><TD>8/5/2011</TD><TD> </TD><TD>8/6/2011</TD><TD> </TD></TR><TR><TD>2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>3</TD><TD>Allana Anderson</TD><TD>Present</TD><TD>10:29:07 AM</TD><TD>Present</TD><TD>10:29:07 AM</TD></TR><TR><TD>4</TD><TD>Jane Barker</TD><TD>Present</TD><TD>10:29:07 AM</TD><TD>Present</TD><TD>10:29:07 AM</TD></TR><TR><TD>5</TD><TD>Mike Ruffle</TD><TD>Present</TD><TD>10:29:09 AM</TD><TD>Abscent</TD><TD>Death in family</TD></TR><TR><TD>6</TD><TD>David Gilberson</TD><TD>Excused</TD><TD>doctors Appt</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>7</TD><TD>Bella Nuance</TD><TD>Present</TD><TD>10:29:10 AM</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>8</TD><TD>June Shine</TD><TD>Late</TD><TD>in at 10:00am</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>9</TD><TD>Allison Smith</TD><TD>Present</TD><TD>10:29:10 AM</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>10</TD><TD>Maria Thomas </TD><TD>Present</TD><TD>10:29:11 AM</TD><TD>Present</TD><TD>10:29:11 AM</TD></TR><TR><TD>11</TD><TD>Jeff Daniels</TD><TD>Absent</TD><TD>abscent kids were sick</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>12</TD><TD>Bayley Hanson</TD><TD>Present</TD><TD>10:29:13 AM</TD><TD>Present</TD><TD>10:29:10 AM</TD></TR><TR><TD>13</TD><TD>Adam Fredricks</TD><TD>Present</TD><TD>10:29:13 AM</TD><TD>Present</TD><TD>10:29:13 AM</TD></TR><TR><TD>14</TD><TD>Sarah Sky</TD><TD>Present</TD><TD>10:29:14 AM</TD><TD>Present</TD><TD>10:29:14 AM</TD></TR><TR><TD>15</TD><TD>Brian Johnson</TD><TD>Present</TD><TD>10:29:14 AM</TD><TD>Late</TD><TD>arrive 11am</TD></TR><TR><TD>16</TD><TD>Ellie Dayson</TD><TD>Present</TD><TD>10:29:15 AM</TD><TD>Present</TD><TD>10:29:15 AM</TD></TR>
</TABLE>
