copying from worksheets

  • Thread starter Thread starter Mal
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel lookup across entire workbook 1
Copy certain rows to new worksheet 1
Collating from worksheets 9
Excel Count If Formula Question 1
Search , then copy and paste from multiple worksheets. VBA help 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Copy Cells from multiple Worksheets in same workbook. 2

Back
Top