MS Project 2007 Macro

[johann123]

I need help creating a macro that will copy the previous week's entries in the "Resource View" to a custom view in the "Gannt View".

So, for example if a resource worked 16hrs the previous week on a task, then I would like to see 16 hrs in a custom field in the "Gannt view".

Thanks much