| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested Loop
Thanks Dave, i'll look into this articles
"Dave Peterson" wrote: If you could put the indicator on each line, then it sounds like a pivottable would work nicely. To add the Title to each subsequent row, look at Debra Dalgleish's site: http://www.contextures.com/xlDataEntry02.html Then you could use a dynamic range name to make the pivottable will reflect the current data--again from Deb's site: http://www.contextures.com/xlNames01.html#Dynamic And finally, some links for learning about pivottables. Debra Dalgleish's pictures at Jon Peltier's site: http://www.geocities.com/jonpeltier/...ivottables.htm And Debra's own site: http://www.contextures.com/xlPivot01.html John Walkenbach also has some at: http://j-walk.com/ss/excel/files/general.htm (look for Tony Gwynn's Hit Database) Chip Pearson keeps Harald Staff's notes at: http://www.cpearson.com/excel/pivots.htm MS has some at (xl2000 and xl2002): http://office.microsoft.com/downloads/2000/XCrtPiv.aspx http://office.microsoft.com/assistan...lconPT101.aspx ====== I find that if I lay out my data nicely, then I can use the features/functions that are built into excel. It really makes life easier in the long run. Federico Ginnari wrote: Dave, thanks for your help too, i've been trying to get this data - subtotal to work with my project but i don't think it's the way to go, all this extra information that this function adds messes up the rest of the information in the sheet, and to be hones, it just gives you to much sub totals!. is there another way to do this??? the big problem that i'm having on this proect is that the data is not always the same size, i mean the titles even thought they are on the same column, but they are not always on the same row, and some titles have more items that others. on my 1st post i have an example of the code, any other comments are apriciated, thanks. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested If Loop Limitation for Excel 2003 | Excel Discussion (Misc queries) | |||
| Nested loop | Excel Worksheet Functions | |||
| Nested Loop Link | Excel Worksheet Functions | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
| Nested loop with ranking | Excel Programming | |||
![Federico Ginnari[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
