ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create a summary list using same fields from multiple sheets (https://www.excelbanter.com/excel-discussion-misc-queries/157219-create-summary-list-using-same-fields-multiple-sheets.html)

PaulG

Create a summary list using same fields from multiple sheets
 
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

Max

Create a summary list using same fields from multiple sheets
 
"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
---


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com