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 Pulling data from other Excel sheets

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
Pulling one cell from Multiple sheets to one sheet Vick Excel Discussion (Misc queries) 2 May 14th 07 06:57 PM
Need help with a formula pulling data from mutilple sheets walkerT Excel Discussion (Misc queries) 6 March 12th 07 08:56 PM
Pulling Data in Excel kitkatq Excel Worksheet Functions 3 September 26th 06 07:45 PM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
pulling info from multiple sheets Jimenda Excel Discussion (Misc queries) 2 December 23rd 05 10:04 PM


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