VBA Column Condense in access

Hi

i have been using this in Excel and has been running fine but a little slow for my liking.

would someone be able to replicate the relevant VBa coding for access to run this within the database so it updates the main table?
the table has 95 columns

Name|Skill|Team|1/1/15|2/1/15 Etc

Please Login or Register  to view this content.

Thanks

Rob

HI

I have managed to get the function working..just need to workout how to get a macro to call this?

any ideas?

Please Login or Register  to view this content.

It would have to have 365 append queries?

This is converting where i have the following columns
Name | Skill | Team | 01/01/2015 | 02/01/2015 | 03/01/2015| to 31/12/2015

I want to keep most of the processing in access as this removes the majority of the coding from the users workbook.

Thanks

Rob