Text data -- linking Excel sheets

M

MM

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?
 
D

dlw

Yes, you can reference text cells in other sheets (like sheet1!B2) just like
you can reference numeric cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Linking data in MS Word into Excel 5
Linking Child Timelines to Multiple Parents 0
Averaging Data across multiple sheets 0
I want to link sheets in excel to a master sheet in excel 1
linking excel sheets 0
Many sheets, one DB? 1
Need help deleting data 2

Top