Excel question

Locked

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!

Topic

Excel question

In reply to Excel question

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.

Excel question

In reply to Excel question

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.

Excel question

In reply to Excel question

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.

Excel question

In reply to Excel question

Poster rated this answer

Excel question

In reply to Excel question

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

Excel question

In reply to Excel question

Poster rated this answer

Excel question

In reply to Excel question

This question was closed by the author

[Author]

Replies