Posted to microsoft.public.excel.misc

Posts: n/a

Index?

I have a workbook with 30 tabs, all of which have the same format. I'm
trying to create a summary worksheet that references the same cells in all 30
worksheets. I don't want to do the ='Sheet1' then =Sheet2 etc. for all 30
tabs and I know there is an easier way but I can't remember how. I seem to
recall Index but I don't completely understand how it works. Any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Index / Hlookup	Pamela Creighton	Excel Worksheet Functions	1	February 5th 06 07:22 PM
Formatting result of Index function	ExcelFred	Excel Worksheet Functions	5	July 26th 05 01:34 PM
cell color index comparison	MINAL ZUNKE	New Users to Excel	1	June 30th 05 07:11 AM
Min formula not returning value from Index	ExcelMonkey	Excel Worksheet Functions	3	January 29th 05 01:47 AM
index to a range of cells	Frank Kabel	Excel Worksheet Functions	0	October 27th 04 05:39 PM

All times are GMT +1. The time now is 02:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us