PC Review


Reply
Thread Tools Rate Thread

Create a summary list using same fields from multiple sheets

 
 
=?Utf-8?B?UGF1bEc=?=
Guest
Posts: n/a
 
      6th Sep 2007
I have a series of data forms (each identical in format) and want to creat a
summary list on a seperate worksheet drawing the data from the same range of
cells in each individual worksheet
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWF4?=
Guest
Posts: n/a
 
      6th Sep 2007
"PaulG" wrote:
> I have a series of data forms (each identical in format) and want to creat a
> summary list on a seperate worksheet drawing the data from the same range of
> cells in each individual worksheet


Try this sample from my archives which illustrates a way:
http://savefile.com/files/414328
Interactive Summary.xls
(full details inside ..)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create tables on multiple sheets from list monden2 Microsoft Excel Programming 3 13th Apr 2010 01:18 PM
Create List sourced from Multiple sheets of varying lengths desertSol Microsoft Excel New Users 1 21st Oct 2009 10:05 PM
Create summary sheet of last row of info from other sheets Lisa Microsoft Excel Worksheet Functions 5 14th Dec 2007 03:57 PM
Create Summary Sheets MRS698@yahoo.com Microsoft Excel Programming 0 31st Jul 2006 10:51 PM
Create a List from Same Cell on Multiple Sheets Fritz Buchman Microsoft Excel Discussion 8 10th May 2004 04:52 AM


Features
 

Advertising
 

Newsgroups
 


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