Copy out one worksheet as values, breaking links

[rickinnocal]

Hi, in a multi-sheet workbook there is one sheet called "Summary".

All the data on that sheet is either linked over from other sheets, or calculated. There is no data entered on the sheet at all.

In the past, we have printed the sheet as a pdf and emailed it to the client.

(As background, the sheet was sent to us as a one-page workbook by the client, for us to complete and return as a pdf. I embedded the sheet into our full report so that it wouldn't require duplicate data entry)

Well, now the client wants us to return the sheet to them as a one-page Excel, as they have written an Access app that sucks the data out of the worksheet and puts it in a database.

I know I can copy the worksheet and then go Data / Edit Links / Break Links, but is there an easy way to maybe just do that via a "Copy out Summary" Button?

[davesexcel]

You should be able to select all the data, then Copy and pastespecial values.