Bob Phillips wrote:
Don,

I don't understand why you need a formula at all, why not just simple links
back to the data?

Can you also post the formula, albeit incomplete, that you envisage?


Bob,

I am using links but the IF formula decides where to look depending on
the control number set by the scroll bar. The idea is to keep the
template table static and the table data to appear within the template
window depending on the scroll bar selection. The formula below has
been copied over to three template tables all in a row for Oct Nov Dec
which allows me to pick out each shift easily. Hope this helps


=IF($B$71=1,B76,IF($B$71=2,B105,IF($B$71=3,B134,IF ($B$71=4,B163))))

Regards

Don