Make up a Excel template by removing all the individual specific date removed, and save it as (Save As: Template *.xlt).
Then when you want to create a new spreadsheet for a new person just open the template. When you go to save it, it will be automatically saved (unless you change the default) as a regular spreadsheet (.xls).
I work in a Doctors surgery and I'm creating a Spread Sheet for a select number of patients to monitor their blood results.
I need about 30 charts on each patients sheet, To save me doing each one seperately I have tryed to copy and paste them in to the next patients details.... But all the charts refer to the previous patients details. Is there anyway of copying them so that they relate to the sheet they are copied in to?
Alexandra Huckerby (fustrated and tired!! )