Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text data -- linking Excel sheets
Say if I am surveying 10 people and am asking 5 questions of each and those
questions have a text answer (i.e. a sentence or phrase). 1. In Excel 2000, can a master sheet be created listing the text answers to Question 1 from the Excel sheets of the 10 different people? I know this is done with numeric data but I need to know for text. 2. If Excel 2000 can't, how about 2007? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text data -- linking Excel sheets
Yes, you can reference text cells in other sheets (like sheet1!B2) just like
you can reference numeric cells. "MM" wrote: Say if I am surveying 10 people and am asking 5 questions of each and those questions have a text answer (i.e. a sentence or phrase). 1. In Excel 2000, can a master sheet be created listing the text answers to Question 1 from the Excel sheets of the 10 different people? I know this is done with numeric data but I need to know for text. 2. If Excel 2000 can't, how about 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking sheets to summarize data | New Users to Excel | |||
linking data between sheets | Excel Discussion (Misc queries) | |||
linking data to specific sheets | Excel Discussion (Misc queries) | |||
Linking data in workbook to its sheets | Excel Worksheet Functions | |||
data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions |