Hi everyone,

I'm new to the forum, have a problem I'm hoping is a rather simple fix.

I am looking to make a duplicate copy of a worksheet in excel 2007 that will update each time the original is modified. Nothing crazy, just a simple duplicate of all data. The worksheet is rather large with multiple colors and macros to indicate various stages of a process. Paste link will not work as the sheet is too large and the colors are not transferred. I spent some time looking at this thread during my search that seemed similar to what I am trying to accomplish, however it was tailored to his document-

http://www.excelforum.com/excel-prog...worksheet.html

I am a novice with VBA, but I assume it can be done? It seems like such a simple function.