Printing Reports From Spreadsheets

Hi,
I use a large spreadsheet as a shift roster planner for staff. After the first couple of colums that contain name, I/D number etc for each individual, each column represents one day. Each row represents one individual.

The cells contain what shift that person is doing on each day ( D, L, N or R) or if they are on a particular course, the name of that course.

I'd like to be able to create various reports from the data.

One being for each individual, to show what they are rostered to do each day for the coming 6 months, but not in one long line - ideally broken down into weeks.

The other is to show on a particular date, which individual is doing what shift, or course, grouped together by shift or course.

It's probably a simple task - but I can't figure out how to do it - anyone able to help me please?

This might be simple or it might be extremely complex, depending on how well you want the reports to be formatted.

I would try a simple pivot table. Use another (blank) worksheet in the workbook (or add a new sheet).

On the Excel menu bar, select Data >> Pivot Table Report (or it might say Pivot Table and Pivot Chart Report ..., depending on the Excel version you have).

In Step 1 of the Wizard, accept the default selections
In Step 2 of the Wizard, select the shift table

Play around with this and see if some combination of Pivot Fields and Pivot Tables will satisfy your needs.

Thanks - I've never used pivot tables before, so I although I had an idea that might be the answer I didn't want to spend hours trying to learn about them in case they weren't the right option.

With your advice I'll have a go at mastering them