Check out some similar questions!

RickJ · Feb 6, 2006, 07: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, 07: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, 07: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, 07: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, 10:20 AM

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