Eric wrote in m

keepITcool wrote:


4. Select a cell for your DV dropdown:
set the source of your data validation to =SheetValList
5. Name the input cell
e.g. SheetSelect

... this took care of creating the input cell.

Create your summary range....
=INDIRECT(ADDRESS(ROW(B11),COLUMN(B11),,,SheetSele ct))
(this create an indirect formula that's easy to copy :)


HTH

I was ok till steps 4 & 5. Where do i "set the source of your data
validation to =SheetValList"? I dont understand what you mean there.
If i just enter "=SheetValList" in a cell then Excel pops up a dialog
wanting a file. SheetList is working , if i set up a few cells with
=SheetList i see the names of my worksheets :-) What is
GET.DOCUMENT(88)? Excel Help doesnt find GET, or DOCUMENT - why 88?
Thanks
Eric

Sorry. I (wrongly) assumed you knew what data validation was...

Data Validation will take care that your users cannot enter the wrong
sheet name and with following settings it provides a very convenient
incell dropdown.

4. .. the cell where the users will select the sheet
Via Data/Validation Tab Settings.
Allow: List
Source: =SheetValList

Uncheck Ignore Blank
Check In-Cell Dropdown.

(we'll ignore the other tabs, do those later)
Press ok.

You'll see a dropdown indicator to the right of the cell...
press that and you'll see the items in the range.

The Get.workbook() and get.document() functions are XLM commands.
XLM is the old macro language used before VBA. Documentation can be
downloaded from Microsoft. (excel XLM Function help)

Most of these dont work when called directly from a worksheet,
only on macro sheets.. OR via names :)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam