Summary worksheets

G

Guest

I am trying to create a summary worksheet that will look at the other identical workseets in the same workbook and return other cells within the same row and worksheet based off or the worksheet with the lowest value in a cell (same cell for all worksheets). The number of worksheets is variable. Anyone have any clever ideas?
 
R

Ron de Bruin

Try this Matt
http://www.rondebruin.nl/copy2.htm

If you need more help post back

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Matt said:
I am trying to create a summary worksheet that will look at the other identical workseets in the same workbook and return
Click to expand...
other cells within the same row and worksheet based off or the worksheet with the lowest value in a cell (same cell for all
worksheets). The number of worksheets is variable. Anyone have any clever ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Count If Formula Question 1
Spreadsheet summary automatically referrences totals of worksheets 2
Identical Cells in Multiple Worksheets in one Workbook. 4
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Summing over multiple worksheets 1
Excel lookup across entire workbook 1
VLOOKUP formula for multiple worksheets 4
LIST OF PERSON'S NAMES 1

Top