copying from worksheets

M

Mal

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
 
C

CLR

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
 
Top