importing multiple sheets into a summary matrix

[sutton_rich1]

Hi,

i have multiple sheets with peoples training records on them (formed using drop down lists). as different people inputted the data it is not in the same order but the sheet is self is based on a struture that is the same.

there are also the dates of the retest on the form.

i need to be able to create a summary sheet that takes the names of training and places is across the top of a new sheet, imputs the name of the person on to the vertical axis then places the corresponding retest date against the name and qualification.

any help will be great.

 

[Trevor G]

Welcome to the forum,

Have you considered just using a link formula on the 2nd sheet to each cell, so when the worksheet is being used then it captures the data on the second sheet all that would be needed from there is capturing the used records in a continuos worksheet.

Which version of excel are you using and is it purely a worksheet that is being completed?

 

[sutton_rich1]

Hi Trevor,

the data is not in an order on the sheets as different people have different training so i dont know how the link would work.

I am using Excel 2007.

I have a separate sheet with the current training courses on that feeds the data in the drop down box.

can a macro do the following:

search a vertical column in sheet "training courses" and place the data in a row on the summary sheet.

abstract the name from cell d4 from all of the different sheets and place them vertically in summary sheet.

search for the training recieved for each name and apply the expiry date under the correct training course.

 

[Trevor G]

This sounds as though Vlookup formula should do what you are asking. If you want to fix to Drop downs (Validation lists) then that can trigger the VLookup.

It might be useful to see a sample of your form and how you currently use it. Is there formula etc or is it just a designed sheet?

You can use Excel Jeannie as an add in to be able to copy the worksheet and upload it as it converts the data into HTML coding.

http://www.excel-jeanie-html.de/html/down_en.php

 

[sutton_rich1]

Hi Trevor,

I have put 3 pics below. one of the input sheet, one of the training data (with only few lines - this will continually be added to as different training is addes) and one of the way that the data should be presented.

I hope this helps you help me.

[RANGE=cls:xl2bb-100][XR][XH=cs:15]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][XH]B[/XH][XH]C[/XH][XH]D[/XH][XH]E[/XH][XH]F[/XH][XH]G[/XH][XH]H[/XH][XH]I[/XH][XH]J[/XH][XH]K[/XH][XH]L[/XH][XH]M[/XH][XH]N[/XH][/XR][XR][XH]4[/XH][XD=cs:3|h:l|fw:b]Name[/XD][XD=cs:4][/XD][XD=cs:3|h:c|fw:b]DOB[/XD][XD=cs:4][/XD][/XR][XR][XH]5[/XH][XD=cs:3|h:l|fw:b]Occupation / Level[/XD][XD=cs:4][/XD][XD=cs:3|h:c|fw:b]Department[/XD][XD=cs:4][/XD][/XR][XR][XH]6[/XH][XD=cs:3|h:l|fw:b]Nationality[/XD][XD=cs:4][/XD][XD=cs:3|h:c|fw:b]SS No.[/XD][XD=cs:4][/XD][/XR][XR][XH]7[/XH][XD=cs:3|h:l|fw:b]English[/XD][XD=h:c|fw:b]1st[/XD][XD][/XD][XD=cs:2|h:c|fw:b]Fluent[/XD][XD][/XD][XD=cs:2|h:c|fw:b]Spoken[/XD][XD][/XD][XD=cs:2|h:c|fw:b]Written[/XD][XD][/XD][/XR][XR][XH]8[/XH][XD=cs:3|h:c|fw:b]Driving[/XD][XD=cs:4|h:c]Up to 3600Kg[/XD][XD][/XD][XD=cs:2|h:c]c/w Trailer[/XD][XD][/XD][XD=cs:3|h:c]Notes[/XD][/XR][XR][XH]9[/XH][XD=cs:3|h:c]Jersey Licence[/XD][XD=cs:4|h:c]Up to 7500kg[/XD][XD][/XD][XD=cs:2|h:c]c/w Trailer[/XD][XD][/XD][XD=cs:3][/XD][/XR][XR][XH]10[/XH][XD=cs:3|h:c]Y/N[/XD][XD=cs:4|h:c]HGV[/XD][XD][/XD][XD=cs:2|h:c]c/w Trailer[/XD][XD][/XD][XD=cs:3][/XD][/XR][XR][XH]11[/XH][XD=h:l|fw:b]Key Skills[/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]12[/XH][XD=cs:14][/XD][/XR][XR][XH]13[/XH][XD=cs:14][/XD][/XR][XR][XH]14[/XH][XD=cs:14][/XD][/XR][XR][XH]15[/XH][XD=cs:14][/XD][/XR][XR][XH]16[/XH][XD=cs:14][/XD][/XR][XR][XH]17[/XH][XD=cs:14][/XD][/XR][XR][XH]18[/XH][XD=cs:14][/XD][/XR][XR][XH]19[/XH][XD=cs:9|h:l|fw:b]Certification[/XD][XD=cs:3|h:c|fw:b]Certificate No.[/XD][XD=cs:2|h:c|fw:b]Expiry Date[/XD][/XR][XR][XH]20[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]21[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]22[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]23[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]24[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]25[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]26[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH]27[/XH][XD=cs:9|h:l]training_courses[/XD][XD=cs:3][/XD][XD=cs:2][/XD][/XR][XR][XH=cs:15][RANGE][XR][XD]Master[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

[RANGE=cls:xl2bb-100][XR][XH=cs:2]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][/XR][XR][XH]1[/XH][XD=h:l]180 Excavator Crawler & Wheeled above 5t[/XD][/XR][XR][XH]2[/XH][XD=h:l]360 Excavator as Drilling Rig[/XD][/XR][XR][XH]3[/XH][XD=h:l]360 Excavator Crawler & Wheeled above 10t[/XD][/XR][XR][XH]4[/XH][XD=h:l]360 Excavator Crawler & Wheeled below 10t[/XD][/XR][XR][XH]5[/XH][XD=h:l]Abrasive Wheels (Fitting & Inspection)[/XD][/XR][XR][XH]6[/XH][XD=h:l]Accident investigation and reporting[/XD][/XR][XR][XH]7[/XH][XD=h:l]Asbestos Awareness[/XD][/XR][XR][XH]8[/XH][XD=h:l]Butt fusion of PE pipe[/XD][/XR][XR][XH]9[/XH][XD=h:l]CAT and Genny Training[/XD][/XR][XR][XH]10[/XH][XD=h:l]CINTEC Approved Installer[/XD][/XR][XR][XH]11[/XH][XD=h:l]CITB: Construction Site Managers Safety Certificate[/XD][/XR][XR][XH]12[/XH][XD=h:l]Confined space awareness[/XD][/XR][XR][XH]13[/XH][XD=h:l]Confined Space Entry and Escape breathing Aparatus[/XD][/XR][XR][XH=cs:2][RANGE][XR][XD]Training Courses[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

[RANGE=cls:xl2bb-100][XR][XH=cs:5]Excel Workbook[/XH][/XR][XR][XH][/XH][XH]A[/XH][XH]B[/XH][XH]C[/XH][XH]D[/XH][/XR][XR][XH]1[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]2[/XH][XD=h:l]Name/Qual[/XD][XD=h:l|cls:fx][FORMULA=='Training Courses'!A1]180 Excavator Crawler & Wheeled above 5t[/FORMULA][/XD][XD=h:l|cls:fx][FORMULA=='Training Courses'!A2]360 Excavator as Drilling Rig[/FORMULA][/XD][XD=h:l]IOSH working Safely[/XD][/XR][XR][XH]3[/XH][XD=h:l]x[/XD][XD=h:r]15/03/2012[/XD][XD][/XD][XD=h:l]N/A[/XD][/XR][XR][XH]4[/XH][XD=h:l]y[/XD][XD][/XD][XD=h:r]15/03/2012[/XD][XD=h:l]N/A[/XD][/XR][XR][XH]5[/XH][XD=h:l]z[/XD][XD=h:r]22/09/2011[/XD][XD][/XD][XD][/XD][/XR][XR][XH]6[/XH][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH=cs:5][RANGE][XR][XD]Matrix[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

 

[Trevor G]

Rich,

I have had to reconstruct your spreadsheet as the copied data didn't come through in a readable manor. But I have an HTML application so I have looked at it and then copied it across into Excel.

First sheet is a Master Sheet which I assume you will duplicate when needed.

Second sheet is the courses list which I would use a named range with and use a validation to ensure the list is the only list that can be used.

So the part that needs working on is Users name appears in D1 (Which is a merged cell), Certifcation (Courses list appears here from Cell A17 downwards, again merged cells, I have validated this to use the course list you provided). And M17 (downwards)again another merged cell.

You then need a list of names, Certification and Expiry Dates in a Summary sheet.

Are you wanting the Summary list to appear in a Sheet within this Workbook? What do you want to happen if you add another sheet?

You could add a Macro (Alt + F8) then run it, so you click on each sheet to transfer to the Summary and date and time a cell to say it has happened ! Then lock the sheet so it can't be done again.

Master

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold" colSpan=3>Name</TD><TD colSpan=4> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=3>DOB</TD><TD colSpan=4> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold" colSpan=3>Occupation / Level</TD><TD colSpan=4> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=3>Department</TD><TD colSpan=4> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold" colSpan=3>Nationality</TD><TD colSpan=4> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=3>SS No.</TD><TD colSpan=4> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold" colSpan=3>English</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">1st</TD><TD> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=2>Fluent</TD><TD> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=2>Spoken</TD><TD> </TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=2>Written</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=3>Driving</TD><TD style="TEXT-ALIGN: center" colSpan=4>Up to 3600Kg</TD><TD> </TD><TD style="TEXT-ALIGN: center" colSpan=2>c/w Trailer</TD><TD> </TD><TD style="TEXT-ALIGN: center; TEXT-DECORATION: underline" colSpan=3>Notes</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center" colSpan=3>Jersey Licence</TD><TD style="TEXT-ALIGN: center" colSpan=4>Up to 7500kg</TD><TD> </TD><TD style="TEXT-ALIGN: center" colSpan=2>c/w Trailer</TD><TD> </TD><TD colSpan=3> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center" colSpan=3>Y/N</TD><TD style="TEXT-ALIGN: center" colSpan=4>HGV</TD><TD> </TD><TD style="TEXT-ALIGN: center" colSpan=2>c/w Trailer</TD><TD> </TD><TD colSpan=3> </TD></TR><TR style="HEIGHT: 36px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-WEIGHT: bold">Key Skills</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD colSpan=14> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: left; FONT-WEIGHT: bold" colSpan=9>Certification</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=3>Certificate No.</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold" colSpan=2>Expiry Date</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD colSpan=9> </TD><TD colSpan=3> </TD><TD colSpan=2> </TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Training Courses

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 304px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Courses</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-SIZE: 10pt">180 Excavator Crawler & Wheeled above 5t</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-SIZE: 10pt">360 Excavator as Drilling Rig</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-SIZE: 10pt">360 Excavator Crawler & Wheeled above 10t</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-SIZE: 10pt">360 Excavator Crawler & Wheeled below 10t</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-SIZE: 10pt">Abrasive Wheels (Fitting & Inspection)</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-SIZE: 10pt">Accident investigation and reporting</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-SIZE: 10pt">Asbestos Awareness</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-SIZE: 10pt">Butt fusion of PE pipe</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-SIZE: 10pt">CAT and Genny Training</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="FONT-SIZE: 10pt">CINTEC Approved Installer</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="FONT-SIZE: 10pt">CITB: Construction Site Managers Safety Certificate</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-SIZE: 10pt">Confined space awareness</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-SIZE: 10pt">Confined Space Entry and Escape breathing Aparatus</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[sutton_rich1]

Hi Trevor,

again thank you for the help.

what you have described is correct, in my work book there is approximately 60 members of staff and about 100 training courses.

the summary can either be a separate spreadsheet or a sheet in the same workbook.

when i add another member of staff or do updates to the sheets in there it needs to come onto the matrix.

 

[Trevor G]

Rich,

Ive worked on the basic and created a workbook with 2 macros, can you send me a pm (private message) so I can send the samples to you.