Copy worksheet values and formats into another workbook
 

Hello,

I have a question...

Let say I run a report that has horrible formatting.
I spend 10 minutes reformatting it then begin making notes on eac
entry (for example - lists of people's names and how far along they ar
on something)
I name the file Week 1

Next week I run the report again and have to reformat...again an
transfer all of Week 1's information onto it, then make updated notes.

What I'm looking for is a report formatting macro or something that
can pull one report, add information then pull another report th
following week, click a button and have it format it just like th
first one and pull over last week's data in addition to the ne
information.

Does that make sense? Sounds kind of confusing by I think it should b
too hard to do. I just can't figure it out.

Thanks!

--
bishwin
-----------------------------------------------------------------------
bishwino's Profile: http://www.excelforum.com/member.php...fo&userid=2915
View this thread: http://www.excelforum.com/showthread.php?threadid=48879