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?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"don" wrote in message
...
Bob Phillips wrote:
There is bound to be another way, using some sort of lookup probably.

Can you give some details of the data, and what you need to do
specifically,
and expected results?

Bob not sure how to explain further but here goes

Table below shows one group of workers for october the codes represent
their attendance.

There are 3 other shifts of workers and this information resides in
their own shift 1 2 3 & 4 workbook.

I use a seperate workbook to pull in all the information from the four
shifts and different locations.

At present I use to good system of paste links to a spreadsheet that
holds all four shifts (located further down spreadsheet so the user
cannot see them without scrolling down) and use what you might call a
template table at the top of the spreadsheet to house all of the common
heading such as dates etc

Template Table

October
Location 1
Shift 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 etc

Bob 1 1 1 1 1 1 r r 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
John 1 1 1 1 1 A A A A A A A A A A A A A 1 1 1 1 1 1
Bill 1 1 1 1 R R 1 1 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
Mike 1 1 1 1 1 r r 1 1 1 1 1 1 1 1 1 r r 1 1 A A A A

<<<<<<Scroll Bar


Then using a form scroll bar inserted below the template table I use
nested if functions to display the shift table data within the template
structure.

Hidden data tables

October
Location 1
Shift 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 etc

Bob 1 1 1 1 1 1 r r 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
John 1 1 1 1 1 A A A A A A A A A A A A A 1 1 1 1 1 1
Bill 1 1 1 1 R R 1 1 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
Mike 1 1 1 1 1 r r 1 1 1 1 1 1 1 1 1 r r 1 1 A A A A



October
Location 1
Shift 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 etc

Neil 1 1 1 1 1 1 r r 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
Bob 1 1 1 1 1 A A A A A A A A A A A A A 1 1 1 1 1 1
Ralph 1 1 1 1 R R 1 1 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
Mike 1 1 1 1 1 r r 1 1 1 1 1 1 1 1 1 r r 1 1 A A A A



October
Location 1
Shift 3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 etc

Bob 1 1 1 1 1 1 r r 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
John 1 1 1 1 1 A A A A A A A A A A A A A 1 1 1 1 1 1
Bill 1 1 1 1 R R 1 1 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
Mike 1 1 1 1 1 r r 1 1 1 1 1 1 1 1 1 r r 1 1 A A A A

October
Location 1
Shift 4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 etc

Bruce 1 1 1 1 1 1 r r 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
John 1 1 1 1 1 A A A A A A A A A A A A A 1 1 1 1 1 1
Paul 1 1 1 1 R R 1 1 1 1 1 1 1 1 r r 1 1 1 1 1 1 1 1
Mike 1 1 1 1 1 r r 1 1 1 1 1 1 1 1 1 r r 1 1 A A A A



Whilst I can do this already and can display one month and the four
shifts within the one template I cant display one shift over 12 months
because I run out of if functions.


Help :-)

rEgards

Don