How to import data from specific column?

R

Ruslan

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
 
R

Ruslan

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?
 
M

Myrna Larson

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.
 
G

Gord Dibben

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
 
Top