johnturgoose
Technical User
I have 2 workbooks.
One is internal holding all information. The second is a summary for sending out to external parties. The 'Summary' workbook draws its data via pasted links to cells in the main workbook.
The problem being if I email out the summary sheet the doctor opening it at the other end will not be able to see any data.
Is there any way of taking a 'snapshot' of the data at a moment in time and effectivly holding the values in the cells rather than the referenced value thus allowing me to send out the update without the main workbook to reference from.
All help gratefully accepted.
Many Thanks
John
One is internal holding all information. The second is a summary for sending out to external parties. The 'Summary' workbook draws its data via pasted links to cells in the main workbook.
The problem being if I email out the summary sheet the doctor opening it at the other end will not be able to see any data.
Is there any way of taking a 'snapshot' of the data at a moment in time and effectivly holding the values in the cells rather than the referenced value thus allowing me to send out the update without the main workbook to reference from.
All help gratefully accepted.
Many Thanks
John