OK, well here's my problem in simplifying the data..

- Each file currently contains information about each person (I realise
that this should really be stored speperately from each week's data, but
that doesnt really impact this problem)

- In each file, there are 3 tabs of information (they have to be kept
seperate for process to run)

- For each week, there is a number for each day, plus the three totals
that it leads to..

eg
Mon--Tues--Weds--Thurs--Fri--Sat--Sun--TOTAL1--TOTAL2--TOTAL3

In order to put this all into one file, I would have to have the name
(and the details about that person) followed by 365 days, and 3 totals
(x 52, as there are 3 totals for each week)

- The list contains hundreds of names, and can change on a daily
basis...for the purposes of inputting the numbers each day, inputting
the numbers into the full list of people would be very difficult to
manage. In addition to this, the data is very much managed on a weekly
basis.

Obviously this makse the management of the data quite difficult,
particular considering that the peopel using it have very limited
computer experience and ahve to fit in with another manual system


I think I've just pretty much answered my own question in that it
cannot be done, lol


--
grey
------------------------------------------------------------------------
grey's Profile: http://www.excelforum.com/member.php...o&userid=17951
View this thread: http://www.excelforum.com/showthread...hreadid=496388