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: 27
Default How to summarize 3-4 worksheets worth of data into a summary scree

Hi all

As aprt of doing a mail merge I need data from 3 worksheets to be summarised
in a 4th worksheet for mail merge reasons.

So what i have currently is a bunch of colums and rows whcih will
continously added to. Currently have around 100 candicates and on each person
there are several further colums for their data. Each person has a similar
setup in 2 other worksheets for different sets of data.

What i want is basically the 4th worksheet to show all of these and also
whenever more data is added to either sheet, this is added to the 4th
worksheet....


Thanks in advance.
 
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
Need help using data from multiple worksheets to create a Summary Ted Thomson Excel Discussion (Misc queries) 3 August 1st 08 12:01 AM
summarize data from multiple worksheets cdshon Excel Discussion (Misc queries) 6 December 28th 06 03:48 PM
help need to total a months worth of worksheets into one report Cathi New Users to Excel 1 October 15th 06 04:46 AM
Creating a summary sheet from data across multiple worksheets Mookarts Excel Discussion (Misc queries) 1 July 17th 06 11:51 AM
Summarize multiple worksheet detail on summary sheet 061931 Excel Discussion (Misc queries) 6 May 23rd 05 02:09 PM


All times are GMT +1. The time now is 11:11 PM.

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"