Workbook format

[axmt]

Hi,

I have an Excel workbook and its data change everyday. What I want to do is to use a workbook with a specific format (colors,letter ...) that receives data of the other workbook I have.

How can I do it?

Thanks.

[starguy]

Your question is not elaborative of your requirement, you should explain it in detail with reference of workbooks.

[axmt]

Well,

I'm going to explain it in more detail. The user uses Discoverer, a Business Intelligence tool. He exports Discoverer workbook to Excel, and when Discoverer exports it, format of Excel workbook is always the same and the user wants to have his own format.

The solution I found is to open another Excel workbook with the format wished by the user and export data from the other workbook. I know that it's possible to do this in Excel but I don't know how.

I hope the question is clear now.

Thanks.