Excel doesn't do this kind of stuff very well.

If I were you, I'd keep all my data in one worksheet. Then I could apply
sorts/filters/charts/pivots much easier.

Idolminder wrote:

Here is the data:
On worksheet 1

Task Milestone
walk _
run _
sprint _

I want to be able to enter an integer in the Milestone field (say 1 to 5).

I have 5 other worksheets (one for each Milestone).

When I enter a 1 in the milestone field, then it would go to the Milestone 1
worksheet, insert a row and copy in the information from the Task field.

thoughts?

--

Dave Peterson