You can do that with a worksheet_change event to copy the info to the next
available row in your desired sheet but it would probably be much better to
just keep all info on the original and use DATAFILTERAUTOFILTER to see
just 525 info.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neal Ostrander" wrote in message
...
Is there a way to have excel add information input on one sheet to a
specific
worksheet. For example tracking fleet maintence information. If the user
inputs truck #525 then the information input would be copied to 525's
worksheet.
Thanks for any help
Neal