I have a file containing a number of different worksheets.
The first worksheet is a summary.
The other worksheets are named individuals onto a calender. The summary
shows what they did each week.
I need to copy each individuals detail from the cells in the summary onto
their own page, as it is entered. Saves me time copying. Is it possible.
For example i dont need Mr Smiths details on Mr Jomnes individual sheet.

Mal

You might be interested in what the Data > Filter > AutoFilter feature can do
for you when applied to the Summary sheet............you can filter so that
you see only each individuals data, and/or portions of it..........you may
not need to do a lot of copying after that.........

Vaya con Dios,
Chuck, CABGx3




"Mal" wrote:

> I have a file containing a number of different worksheets.
> The first worksheet is a summary.
> The other worksheets are named individuals onto a calender. The summary
> shows what they did each week.
> I need to copy each individuals detail from the cells in the summary onto
> their own page, as it is entered. Saves me time copying. Is it possible.
> For example i dont need Mr Smiths details on Mr Jomnes individual sheet.
>
> Mal
>
>
>