2002 excel microsoft training - summarising data

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

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

2002 excel microsoft training - Summarising data

resolvedResolved · Low Priority · Version 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:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

View all Excel hints and tips


Server loaded in 0.08 secs.