Reply to thread

Message: [QUOTE="JBeaucaire, post: 3196073"] Okay, that's more difficult. A self-creating list on Sheet2 using the same idea as a VLOOKUP does for 1 value/cell, you want a list created the same way. [URL]http://home.pacbell.net/beban/[/URL] That website offers some user-defined-functions that all inter-relate. The one you want to use here is VLOOKUPS. It's an array formula. You will need to copy the code for VLOOKUPS and a few other supporting functions into a module in your workbook. Copy the code for the functions: VLookups ArrayCountIf ArrayDimensions MakeArray Then, on sheet2, enter a standard VLOOKUP type formula: =VLOOKUPS("Y",Sheet1!$B$2:$D$10000,3) When you press Enter, a message will appear int he cell telling you how many cells downward you need to select. Highlight the cell and enough below to complete the requested number, press F2, then CTRL-SHIFT-ENTER to activate the array. Two things, first - you will need to be OK swapping the two columns. VLookup needs the column to search on the left. My formula above assumes you will swap the two columns. Second - since you want this summary to fill itself out as you go, even though it says "Select at least 100 rows" or whatever, go ahead and go down much further. The list will expand automatically as you add to the source chart on Sheet1. Hope this works as well for you as it does for me, I use this UDF for several sheets of my own. - Jerry [/QUOTE]