LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 1
Default how to automate a report based in several Workbooks


i'm trying to workout this problem:

I have a workbook that contains data from several workbooks. Each original workbook have data from a particulary month, and every month i have to agregate data from the last 3 month.

Like this, the July report has to have data from June and May. In August, from June and July etc etc.

How can i automate this, just to avoid editing links and formulas every month?

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
I have workbooks to consolidate data from on one report jyinlex Excel Discussion (Misc queries) 0 September 21st 09 04:49 PM
Automate extraction of data from mainframe report into spreadsheet Dave Cox Excel Discussion (Misc queries) 0 December 17th 07 11:09 PM
Compile report from multiple workbooks smonsmo Excel Discussion (Misc queries) 6 October 2nd 07 06:22 PM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
Automate bar chart color based on value postive or negative kathy Excel Discussion (Misc queries) 1 August 31st 05 09:35 PM

All times are GMT +1. The time now is 08:24 AM.

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

About Us

"It's about Microsoft Excel"