I will have 200+ workbooks the first sheet containg employees name and other
information that will be input once and require transfering once, then
another 20 sheets representing assessment unit that will only require failed
assessments to be transfered to the master spreadsheet.

All the infomation needs to be updated to the section of the master
spreadsheet that is for that candidate, the assessment cycle is two yearly so
any rows in the Master over 18 months old need to be deleted (would it be
possible to automate this?)

The master spreadsheet has all the same headings as the ones in the workbook
but in differant places and 200+ times as each member of staff has his/her
own section within the spreadsheet as mentioned above. We need to be able to
use the master too look at both individual data and create nation/regional
reports.

I have trawled the net and can't seem to find any VBA tutorials that can
help me do this. I an a VBA noob so stand no chance of writing this from
scratch is there anyone willing to help me or can anyone point me to any
examples of coding I might be able to adapt?

Thank you all in advance.

Start here
http://www.rondebruin.nl/copy3.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Esposa" wrote in message ...
I will have 200+ workbooks the first sheet containg employees name and other
information that will be input once and require transfering once, then
another 20 sheets representing assessment unit that will only require failed
assessments to be transfered to the master spreadsheet.

All the infomation needs to be updated to the section of the master
spreadsheet that is for that candidate, the assessment cycle is two yearly so
any rows in the Master over 18 months old need to be deleted (would it be
possible to automate this?)

The master spreadsheet has all the same headings as the ones in the workbook
but in differant places and 200+ times as each member of staff has his/her
own section within the spreadsheet as mentioned above. We need to be able to
use the master too look at both individual data and create nation/regional
reports.

I have trawled the net and can't seem to find any VBA tutorials that can
help me do this. I an a VBA noob so stand no chance of writing this from
scratch is there anyone willing to help me or can anyone point me to any
examples of coding I might be able to adapt?

Thank you all in advance.

Thank you I found his link in another of your posts lol I was just searching
to see if he had anything :)

"Ron de Bruin" wrote:

Start here
http://www.rondebruin.nl/copy3.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Esposa" wrote in message ...
I will have 200+ workbooks the first sheet containg employees name and other
information that will be input once and require transfering once, then
another 20 sheets representing assessment unit that will only require failed
assessments to be transfered to the master spreadsheet.

All the infomation needs to be updated to the section of the master
spreadsheet that is for that candidate, the assessment cycle is two yearly so
any rows in the Master over 18 months old need to be deleted (would it be
possible to automate this?)

The master spreadsheet has all the same headings as the ones in the workbook
but in differant places and 200+ times as each member of staff has his/her
own section within the spreadsheet as mentioned above. We need to be able to
use the master too look at both individual data and create nation/regional
reports.

I have trawled the net and can't seem to find any VBA tutorials that can
help me do this. I an a VBA noob so stand no chance of writing this from
scratch is there anyone willing to help me or can anyone point me to any
examples of coding I might be able to adapt?

Thank you all in advance.