Import Data into same cell

[Guest]

Hi,
I need to import data from 5 different spreadsheets into the same cell. For
example, I have one spread sheet that says test1 , Test2, and Test3 spread
over 9 colums and 200 rows in random places. Copy and pasting them into the
master document is easy, but for the next spread sheet, I have Yes, No and
Maybe. I have to import that data into the same cell as the test1 test2 and
test3 cells without overwriting the existing data. Is there a way to do
this? I would hate to manually input this data, it would take for ever.
Thanks in advance.

 

[JulieD]

Hi

not sure what you mean by "import that data inot the same cell as the test1,
test2 and test3 without overwriting the existing data",
do you want to see
test1 yes
in the same cell?

if so, using a formula might be a better way of going e.g.
=Sheet4!B4 & " " & Sheet5!B4
will concatenate the contents of cell B4 in Sheet4 with cell B4 in sheet5 -
this formula can then be filled as required.

Cheers
JulieD

 

[Guest]

Yeah, Thats pretty much what I mean. I want to see test1 and yes in the same
cell. That way when I look at the master document I will see all the data.
For example, if there was a question and on one spreadsheet and the answer
was test1, and on another spreadsheet the answer was yes, I want to be able
to see both answers on the master document, in the same cell. I want to
import all the yes, no's and maybes into the same cells that the test1 test2
and test3 data is in. That way I can see all answers at the same time. I
will try the formula you gave me. I hope that clarified things. Sorry, I am
not good at explaining myself sometimes.

 

[JulieD]

How did you go with the concatenation formula - did it do what you were
after?