How to import data from specific column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,
I would appreciate if you can tell me how I can import data from another
excel file's A column into A column in my new spreadsheet ?
regards,
Ruslan
 
Hi
use a formula such as
='other_sheet'!A1
and copy this formula
 
Dear Frank,

in my case I have very long data...it may take a day to copy one by
one....is there any way to copy all unhidden rows at once?
 
You DO know how to copy a formula down, don't you? You don't have to retype
it. If you need more information on copying formulas, look at Help.
 
Ruslan

In your source sheet select column A and Edit>Go To>Special>Visible cells>OK

Copy and paste to the open target workbook.

If you want links, paste special>links.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing data from Excel worksheet into Excel template 2
VBA - retrieve data on last create named range from previous inserted named range 0
Import External Data 3
Importing data. Problem with datatype in column 2
How pull ID#s that meet specific "yes" requirements 3
Excel 2003 - Importing External Data - formatting problem? 2
import data to specific columns 1

Back
Top