Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ib_redbeard
 
Posts: n/a
Default 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.
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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.



  #3   Report Post  
ib_redbeard
 
Posts: n/a
Default

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.




  #4   Report Post  
JulieD
 
Posts: n/a
Default

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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
Automatic cell increment with data from sheet 1 to sheet 2 Big G Excel Worksheet Functions 2 December 20th 04 06:59 PM
Duplicate data in a cell... The Outlaw Dozy Wales Excel Worksheet Functions 2 December 15th 04 01:31 PM
Retrieve last cell with data JimDandy Excel Worksheet Functions 2 November 20th 04 07:50 PM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"