Can i import one excel file to another excel file?

K

kimbers867

I have a new excel file that I want to update with an older excel file, can I
import the two? There must be an easy way to merge the two together without
having to retype.
 
M

Myrna Larson

Depends on what you mean by update. If it's just to add more data to the
bottom of an existing list, open both files, then select the data, Edit/Copy
it and Edit/Paste to the other workbook.

If that's not what you want, can you be more specific?
 
K

kimbers867

I have a spreadsheet (#1) that lists addresses for several counties, this
spreadsheet is over 1 year old. I have a new spreadsheet that has the same
information but has been newly updated and I want to try and import the new
addresses into the old speadsheet #1 because I have made some modifications .
So I'm trying to see if I can merge the two together without loosing any
information.
 
K

kimbers867

My spreadsheet just consists of two columns and many many rows. Both
spreadsheets are like this but #1 spreadsheet is over a year old with some
modifications by me (adding new rows of addresses). Spreadsheet #2 is the
newer of the two (only 2 columns and tons more rows). I want to incorporate
my changes into #2 by trying to import my info from #1 into #2.
 
F

Frank Kabel

Hi
still lacking details :)
You may post some example rows of data and yourn expected result (plain
text - no attachments please)

--
Regards
Frank Kabel
Frankfurt, Germany

"[email protected]"
 
M

Myrna Larson

Basically, you want to add people from #1 that aren't in #2, right?

Copy the worksheet from the 1st file into the 2nd file and name the sheets
NewData and OldData.

I assume that on each sheet, the names are in column A, addresses in column B,
and you have a header in row 1

On the OldData sheet, cell C2, put this formula:

=COUNTIF(NewData!$A$A,A2)

and copy it down through the last used row.

Use Autofilter on OldData sheet to display only the rows with an 0 in column
C.

Edit/Copy the visible rows, and paste them at the bottom of the list on
NewData.

Then delete column C on the NewData Sheet.

If this isn't what you want, we need more information
 
Top