General discussion

Locked

Excel question

By Jayster7 ·
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!

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel question

by BV2 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.

Collapse -

Excel question

by Jayster7 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.

Collapse -

Excel question

by pVp 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.

Collapse -

Excel question

by Jayster7 In reply to Excel question

Poster rated this answer

Collapse -

Excel question

by tvsm 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

Collapse -

Excel question

by Jayster7 In reply to Excel question

Poster rated this answer

Collapse -

Excel question

by Jayster7 In reply to Excel question

This question was closed by the author

Back to Community Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums