Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

reporting cells common different

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Reporting on cells common to different worksheets

Reporting on cells common to different worksheets

ResolvedVersion 2016

Kate has attended:
Excel Intermediate course

Reporting on cells common to different worksheets

Thanks to Wendy for a great Intermediate training on Friday. But I have a question she thought the Forum could help with!

I have a workbook with severalworksheets in it, listing the different services used by three Clients: A, B and C. On a 4th worksheet, I want to be able to report on which services they all use, as well as which ones only they use. In an ideal world, each common service would also pull some other associated data with it.

I am basically looking to create a report which does the same thing as a Venn diagram, showing where the commonalities are (it doesn't need to look like a Venn diagram!). I have a sample workbook I can share if anyone wants to have a go.

Thanks very much in advance for your collective wisdom!

RE: Reporting on cells common to different worksheets

Hi Kate

If you could email your sample workbook to info@stl-training.co.uk I'll take a look.

Kind regards

Dennis

RE: Reporting on cells common to different worksheets

Thank you so much, Dennis. Sending you an email shortly.
Kate

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.