Import Data into same cell
 

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.

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



"ib_redbeard" wrote in message
...
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.

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" wrote:

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



"ib_redbeard" wrote in message
...
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.

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

"ib_redbeard" wrote in message
...
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" wrote:

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



"ib_redbeard" wrote in message
...
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.