Spreadsheet formatting / Layout?

[jackie77]

Hi All

I am new to excel and I was looking for some help, I have a spreadsheet with a list of Job Id's and addresses etc (exported from access) and I'm now looking to arrange the spreadsheet, I need it to divide the rows into sets of 50 ideally all held on one page, with a number of running calculations placed at the bottom of each page. At the end of the document I would like it to carry out some final calculations. I am not sure if this is possible or even hope to go about it

I would greatly appricate any sugeestions to get me started

Many Thanks

Jackie

[tuph]

It's all possible, Jackie, but it would be easier to make recommendations if we could see what you are working with. I suggest that you zip the file and attach it.

[jackie77]

Thanks for the reply tuph

I have attached a brief example of the kind of info that will be exported over from access, however it will include on average a thousand records/rows. what I am looking for it to to is automatically sort them rows into groups of 50, after each 50 rows calculate for example:

Invoice 1 (first group of 50)
Total number of jobs in entire document i.e. 1000
Total jobs serviced (count 'serviced' row E)
Total to date serviced
Total that require work (Count in Rows I & K 'True' however only count 1 value per row)
Total to date requiring work

Invoice 2 (next 50)
Total number of jobs in entire document i.e. 1000
Total jobs serviced (count 'serviced' row E)
Total to date serviced (count nimber serviced on previous 50 + this 50)
Total that require work (Count in Rows I & K 'True' however only count 1 value per row)
Total to date requiring work (count number requiring work on previous 50 + this 50)

and so on -------

At the end I would like a final summary of
Total number of jobs in entire document i.e. 1000
Total jobs serviced
Total that require work

Sorry if this is long winded I hope I have explained it ok

Any ideas of where I should start?

Jackie

[tuph]

What you want to achieve is beyond my level of expertise, but there's lots of great help on this forum. I'm sure you'll get some good tips.

[jackie77]

Thanks for having a looking and replying anyway

If there is anyone that could get me started it would be most appriciated

Regards

Jackie