Hi "Vibeke"

Missed to mention few points.

1. The workbook should be saved before trying out the formula
2. The sheetname should be exactly same as the venue; meaning; there should
not be any blank spaces etc; in sheet tab names..
3. As the formula picks the sheetname and compare with the 'Master' sheet;
the same formula applies to all 6 venue sheets

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try the below formula. Please note that this is an array formula. Within the
cell in edit mode (F2) paste this formula and press Ctrl+Shift+Enter to apply
this formula. If successful in 'Formula Bar' you can notice the curly braces
at both ends like "{=<formula}"

Sheet1 named as 'Master'
Subsequent sheets named as 'Townsville',and other 5 venues..

In inidividual sheet in Cell A1 enter the below formula and copy that down
as required....

(all in one line)
=IF(ROW()COUNTIF(Master!$B$1:$B$5000,MID(CELL("fi lename",D1),FIND("]",CELL("filename",D1))+1,99)),"",INDEX(Master!$A$1 :$A$5000,SMALL(IF(Master!$B$1:$B$5000=MID(CELL("fi lename",D1),FIND("]",CELL("filename",D1))+1,99),Master!$A$1:$A$5000), ROW())))

Try and feedback


If this post helps click Yes
---------------
Jacob Skaria


"Vibeke" wrote:

Hi,
I have a master worksheet which consists of
Column A1:A5000 is numbers 1-5,000 (being ID numbers on tickets)
Column B1:B5000 is text (being one of six place names, venues for ticket
sales)

In six other (child) worksheets, named for the venues, I'd like to create
lists that others can use to record whether a specific ticket is sold. For
example, if "Townsville" gets tickets 250 to 1200, this would be recorded on
the Parent list and the Townsville worksheet would only list those numbers -
with no blank rows! I may need to amend the master list from time to time-
e.g. if tickets aren't sold in Townsville, they can be re-assigned to
Cityville (and so disappear from the former worksheet and show up in the
latter).

I think I need MATCH, INDEX and\or ROW to do this, but after trying sevreal
options, I'm no closer.

Any ideas? Thanks in anticipation.