LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Auto Populating Data

I have 2 fairly large reports (that have 10 tabs of data) that I do every
week and would like to know if there is a way that I don't have to re-create
these reports each week. Here is what I am currently doing: I export
specific information from ACT! into Excel (this information changes from week
to week). Then I insert several additional columns throughout so that I can
perform various calculation totals. Once this is done I copy/paste the
information that I need into my reports. Hers' my question: Is there a way
that once I have my Exported data ready to go, that I can have the data
necessary to populate automatically over to my reports rather than having to
copy/paste while keeping the format (colors, column widths, formulas, etc.)
in tact?

Any Help would be greatly appreciated!!

Thanks!

Rwilson130
 
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
Auto-populating file based on conditions Alex Excel Discussion (Misc queries) 0 November 29th 07 12:02 AM
Auto Populating and Formatting Data Clark Excel Discussion (Misc queries) 7 October 5th 07 01:07 AM
Help with auto populating cells. Brad Excel Worksheet Functions 4 September 29th 07 02:38 AM
Auto populating date field TimM Excel Discussion (Misc queries) 1 June 19th 06 05:50 PM
Auto populating fields Mark Excel Worksheet Functions 2 September 15th 05 08:46 PM


All times are GMT +1. The time now is 03:47 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"