Sending Data to a second sheet

Hello quasifun,

I removed your file as precaution against any malicious software. Please don't circumvent the security of the Forum. WinZip is standard with Windows 2000 and up. Please use it to avoid this problem in the future.

Sincerely,
Leith Ross

Sorry about the file mixup. I didn't intend to circumvent your security. I don't have Winzip on my computer. Had to take the file home to zip it.

Anyway, I'd like to be able to type into sheet one (Company name) and have it automatically sort it on the second sheet. Is it possible?