Merging Excel Spreadsheets

[Guest]

To whom it may concern;

I currently have two excel spreadsheets that i would like to merge. A bit
o' history:

In my office we have a database in which we enter all of our pertinent data.
However, the database is not equipped with any reporting function and thus
cannot produce reports or run stats for us. As a result we have asked our
administrator to provide us with "dumps" in the form of Excell spreadsheet.
We receive these "dumps" at the end of each month and each "dump" consist of
all historical data as well as any new data entered over the previous month.

In the course of my job I have added a few extra columns to the tabkles in
order to facilitate analysis. What I would like to do is merge the new
"dumps" with the previous tables in which I have added extra columns.

Is there a method to do this, perhaps with the use of named ranges?

Any help would be greatly appreciated as I am dealing with over 10,000
records.

Z

 

[Guest]

Can you just copy and paste one table to the bottom of the other? Or do they
have different structures?

 

[Guest]

Dave,

The table structure is the same (except for the 4 extra columns I have added
for my own purposes). The problem with cutting and pasting is that some of
the records whcih may have been netered 5 years ago, could have been updated
over the course of the previous month. As such I would like to try and avoid
having to go through the whole table. I should note that any changes made to
any recodr is coded with a datestamp.

 

[Guest]

Well, there are a couple of possibilities that occur to me:

1) If the amount of data you have is more than 65000 rows then you can do
this in Access (if you know how to use that program).
2) If the amount of data is less than 65000 rows, then sort the tables by
the datestamp, or whatever your relevant criteria is, delete those rows which
don't match your criteria, and then cut and paste.

To be more concrete about number 2: if your criteria is "I only want data
dated July 1, 2005 and later," then, when you sort your data, just delete all
records whose datestamp is less than 7/1/05.

Hope that helps.

Dave