Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Summarising data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
2002 excel microsoft training - Summarising data
Resolved · Low Priority · Version Standard
Reply Mon 21 May 2007, 16:58Delegate Reyno said...
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?
For upcoming training course dates see: Pricing & availability
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
|