LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
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 07:18 AM
Automatic cell increment with data from sheet 1 to sheet 2 Big G Excel Worksheet Functions 2 December 20th 04 05:59 PM
Duplicate data in a cell... The Outlaw Dozy Wales Excel Worksheet Functions 2 December 15th 04 12:31 PM
Retrieve last cell with data JimDandy Excel Worksheet Functions 2 November 20th 04 06:50 PM


All times are GMT +1. The time now is 11:54 AM.

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

About Us

"It's about Microsoft Excel"