Excel Question

[dglienna]

I have two worksheets that I export to a new workbook, without the formulas. I did this a few months ago, and have the new workbook saved.

The data has changed, and we have to export it again!

My problem was getting the formatting correct for the new sheets.

As long as it is correct now, couldn't I just paste the new data into each sheet as values?

Would it be easier to save the present new workbook as a template? Is that how templates work? Right now, I saved the template with the data in it.
Is this correct?

To copy the data, I just pasted special - values. Is there a better way?

We have to redo the first workbook, and do another one for someone else with different values, so I want to eliminate the having to do the formatting that I did once in the future.

Thanks in advance!