Esposa
01-19-2009, 11:50 AM
I have a workbook with 22 pages the first page is a Employee Assessment plan with their personal details on and details of when they will e assessed and on what they will be assessed in a 2 year period. Sheets 2 to 21 are all individual units thet will be filled in by assessors once the assessment has taken place. The final page is a summary sheet.
I need to create some VBA that will copy any row that has NO in column F to the summary sheet. This workbook will be updated monthly over a two year period so the information only requires copying once if that makes sense.
I then need some VBA that will loop through all the closed workbooks collating the summary sheets into one spreadsheet to enable reports to be created. It would be great if I can get the code to fit in the the master soreadsheet we currently update manually but I am not sure that would work because it requires each member of staff to be updated under their own name everytime.
It seems I can only upload one file at a time so if anyone needs/wants to see the national record worksheet I will have to forward it.
I am new to VBA and don't have a clue where to start, can anyone point me in the right direction?
I need to create some VBA that will copy any row that has NO in column F to the summary sheet. This workbook will be updated monthly over a two year period so the information only requires copying once if that makes sense.
I then need some VBA that will loop through all the closed workbooks collating the summary sheets into one spreadsheet to enable reports to be created. It would be great if I can get the code to fit in the the master soreadsheet we currently update manually but I am not sure that would work because it requires each member of staff to be updated under their own name everytime.
It seems I can only upload one file at a time so if anyone needs/wants to see the national record worksheet I will have to forward it.
I am new to VBA and don't have a clue where to start, can anyone point me in the right direction?