I am currently working on a project where there is a master sheet
linked to about 8 other sheets. This makes data entry easier as all
the fields are located on the master sheet and link to the eight other
sheets (about 1/2 the firelds exist on all sheets). I have figured out
how to list one "list field" from one sheet to the next using "paste
special". My problme is, these lists will ot always be static. One
client may have 30 workstations while another may have 40, for example.
So I have had to create a dynamic list using this function:
=OFFSET([Workstation]Master!$A$8,1,0,COUNTA([Workstation]Master!$A:$A),1)

My issue is, i cant get that list to link between two different
worksheets. I have tried everything i can think of.

Thank you.