Any Excel Wizz's on Here?

[horlock07]

I want to duplicate a sheet so that it mirrors what is shown on another sheet (with the answers to the formulas in the second rather than the formulas).

Its basically so I can set up a template that does the calculation on one sheet whilst the second mirrors this but with a letter head so I can PDF it, to avoid having to do things twice.

Sure there is an easy way, I just don't know it!

[4D]

So you want a duplicate that just shows values when you highlight a cell rather than a formula?

[horlock07]

Yeah something like that.

Long and short is its for invoices. Probably 90% of invoices we send out still go as paper (don't blame me I prepare them don't dispatch them!) but there are some clients who want PDF's and at other times want the paper ones updated and sent as PDF's.

So I have a spreadsheet with a sheet that holds and calculates all the VAT etc, I want to set up a duplicate sheet which holds the same info but with company logos etc added so its easily PDF'ed.

[REDBUCK]

You can create either a new sheet or book where the cell(s) point back to the original cell(s) for the answer rather than the formula.

This new sheet or book can then be saved as a PDF.

[4D]

Move cursor over the tab at the bottom of your worksheet, right click and look at list. Select move / copy. Tick the copy square and select move to end. This creates a duplicate. On the duplicate, click the square in the top left of the worksheet to highlight the whole worksheet,  right click, copy, rightclick paste "value".

[Samdy Gray]

Why the need to do it with two sheets? Surely you just set the one sheet up to be the template that you want, then print to PDF once completed?

In any case, don't you have an accounts system like Xero/Quickbooks etc. to produce invoices?

[Hitchinred]

I would highlight the area you want as pdf. Then do “File Save As” and select PDF as file type. Under the Options select the button “Selection” and then it just saves the highlighted area as pdf.

[horlock07]

Why the need to do it with two sheets? Surely you just set the one sheet up to be the template that you want, then print to PDF once completed?

In any case, don't you have an accounts system like Xero/Quickbooks etc. to produce invoices?

I probably haven't explained it very well. The first sheet is for invoices that go out as paper copies and thus are manually printed and go out on the headed note paper, the second is for when the Client either loses it or queries it and asks for an electronic copy which thus needs the company letterhead and footer to be added as a Jpeg and then the whole shebang Pdf'ed.

As we only do c.10-15 invoices each month specialist software doesn't seem worth it.