Hi
If you did want to use Pivot Tables, I have uploaded your file set out for
use with PT
http://www.freefilehosting.net/download/3a3c9
I have read across just your Week1 data to a format suitable for PT analysis
on a sheet called Data, and sheet Report is a Pivot Table report based on
just that week of data.
I assumed Monday of week1 was 31 Dec 2007 for this purpose.
There is a sheet called Setup, with Validation Lists for Data entry.
On Sheet Data, in the next available row, there are dropdowns to select the
Category, Type and Name.
Column F inserts the Day of the week if this is required, and column G
calculates a week number (forcing Monday 31 Dec 2007 to be in Week 1)
You could hide columns F and G as far as Data entry is concerned, so the in
putter would only have to enter Name, Date, Category, Type and Number
available to them.
On the report you could just select an individual week, or a Month.
You could select just any given day if required and see the results.
In the longer term, this would lead to less work in maintenance as you add
more and more weeks throughout the year..
If you found it easier to do day entry with your existing layout, then you
could just input one day's worth of data, (i.e. just columns A to E ) with
Date in place of Day.
Then use a short macro to write the data out to your data Sheet.
I have included the code to do this in a macro called ConvertData.
Note this assumes that the Source sheet for data entry is still called Week
1 (change in code if necessary) and that the destination sheet is called
Data
--
Regards
Roger Govier
"RMP" wrote in message
...
Thanks Max,
I have uploaded the file, please access on the link below.
http://www.freefilehosting.net/download/3a323
Look forward to hearing back from you.
--
RMP
"Max" wrote:
You could upload a sample of your file,
then post the link to it here
Use either of these free filehosts:
http://www.freefilehosting.net/
http://cjoint.com/index.php
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RMP" wrote in message
...
Hello,
Am I able to attach a spreadsheet to my post so that someone can help
me
with it please? I'm trying to streamline the way my dept records stats
and
the spreadsheet is becoming more complex and difficult to manage as I
progress.
I'm sure there is an easier way to set it up with pivot tables etc,
but, I
lack the knowledge and experience to use pivot tables.
Any help would be invaluable and much appreciated.
Thanks
--
RMP