Merging 2 Excel files

RickJ · #1 Feb 6, 2006, 05:35 AM

I've got a specialized Excel Form that we use to transcribe groups of records:

Here's an example:
http://catholicrecordsociety.org/pro...olunteers.html
(you need to have Macros Enabled)

You'll see that the Card Tab is for entering Records and the Spreadsheet is where they are recorded.

I'd like to merge several of these files into one Spreadsheet. Not finding MSHelp helpful.

How can I do this?

Thanks!

NeedKarma · Feb 6, 2006, 05:49 AM

I would like to go on record as saying: I do not know the answer.

Sounds like you are trying to emulate Access by having a Form entry page and a Table to store the data. You could do the same thing by tweaking your Spreadsheet to allow Data > Form to work. Just a thought.

RickJ · Feb 6, 2006, 05:53 AM

I went to Data > Form to at least see what my options are, but I get a little pop-up that says
"Too Many Fields in the Data Form".

RickJ · Feb 6, 2006, 05:58 AM

Hey, I think I figgered it!

I removed protection from one, selected all rows of the other then pasted them into the first, then just deleted the Card and Housekeeping Tab.

It seems to work fine!

Yes, it's simple. I tried it on another machine and it garbled the records and made the slider not work for the columns...but seems to work just fine now.

SHAVED · Feb 6, 2006, 08:20 AM

Hi rickj.
Why dont you try this link which explains the right way to merge XL Files.
http://support.microsoft.com/?kbid=211802



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!