| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Auto increment over multiple worksheets
I couldn't really figure out how to search the forums for this one... sorry I just don't know the terms that would make a topic such as this one show up for me. My question is, (or is it even possible?) : I am setting up a summary sheet of multiple worksheets and I'm making multiple columns. Each column corresponds to a specific cell in each worksheet I want to be able to drag down a column using the auto increment feature and have it increment the worksheet so that column 1 row 1 has worksheet 1 cell 1 and column 1 row 2 has worksheet 2 cell 1 etc. I'd just like an automatic way instead of having to change the worksheet name each time. -- Ethan ------------------------------------------------------------------------ Ethan's Profile: http://www.excelforum.com/member.php...o&userid=24534 View this thread: http://www.excelforum.com/showthread...hreadid=381267 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| Need to have multiple worksheets use a single worksheet | Excel Worksheet Functions | |||
| fax multiple worksheets | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
