Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy values of worksheet a to workbook b Nev Excel Discussion (Misc queries) 5 April 8th 09 09:35 PM
how to copy only values and formats of worksheets to new workbook rvd Excel Worksheet Functions 3 January 31st 07 12:43 PM
VBA Code to copy values &formats to the next worksheet bobby Excel Programming 9 October 19th 05 02:59 PM
automatically copy values of worksheet into new workbook Jane Excel Programming 4 July 7th 05 03:10 PM
Copy worksheet values and formats into another workbook Rick_Wendt Excel Programming 1 October 20th 04 08:14 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"