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

2002 excel microsoft training - summarising data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Summarising data

2002 excel microsoft training - Summarising data

ResolvedVersion Standard

Reyno has attended:
Excel Intermediate course
Excel Advanced course

Summarising data

I would like to create a sheet which is linked to a current existing sheet so that i can change the information on the existing sheet and it directly affect the new sheet.

The current sheet is series of questions. if somebody puts in the answer i want this to be summarised on the next sheet.


Sheet 1
do you have a dog.....yes
does it eat.................yes

Sheet 2
Dog eat
yes yes

i want the next answer form a different person to come underneath the answer of the first person.

any help with this would be much appreciated?

RE: summarising data

Hello Rayno

This is fairly simple, in that all you need to do is link the details from the one sheet to the other by using =.

Please see the attachement for the example.

Regards

Richard

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

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.