when i input a value in certain in column e1 i want that row to be copied to
a different worksheet on a perticular sheet.

i have a woorksheet name activity in column e i input agent no. i have
different worksheet called agent in that worksheet ihave tabs 1,2,3,4, and so
on till 100 i want when i input say no. 5 in activity sheet in column e the
data for that row ranganging from column a to aa should be copied to
worksheet agent.

is it posibble?
--
Nisha P