Community archive

Ask something
Discussion Locked

Excel question

0 helpful
7 replies

by jayster7

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there any way to combine multiple sheets within a workbook into a single spreadsheet? I was given a workbook with 16 sheets in it, and I was asked to prepare a single dbf file from it. Each sheet is formatted differently also so there's no constant column headers in each. Just in case, I prepared each sheet as a dbf file just in case, but in the meantime, I'm stumped!

7 replies

by bv2

Not sure - off the top of my head I would try to export each page to a csv file and then create a new workbook and merge each csv into the new workbook.

by jayster7

Thanks, but that had occurred to me, and since headers on each sheet were different, I'd still have to do some editing of the sheeet once I merged them. Thanks though for the suggestion.

by pvp

Nope!

One of the basics of dbf's is the "rectangular" shape of records containing the same fields.

Since you have differing header info, you obviously don't have the rectangle.

With a lot of work you could combine everything into one large rectangle, but the results might be meaningless.

by tvsm

I am not quite sure that I understand your question. Why dont you open a new worksheet and copy/paste special/values only. Still some manual work but much easier than creating separate dbf. you can automate by using a macro also

This discussion is closed to new replies.