Hi,

I want to make myself a little project manager. I have three major
clients. Each sends me assignments. On the first "Overview" worksheet,
I'd like to enter these projects row by row as they come in. Then there
should be three additional worksheets, one for each client. The
assignments automatically appear in the appropriate worksheet for the
respective client, row by row.

I know how references work, but I don't know:

a) What do I have to tell Excel so it knows which client worksheet to
write the assignment into?

b) What do I have to tell Excell so it writes the assignment into the
first empty line in the client worksheet?

Thanks.

Ilka


--
IlkaAntonie
------------------------------------------------------------------------
IlkaAntonie's Profile: http://www.excelforum.com/member.php...o&userid=34670
View this thread: http://www.excelforum.com/showthread...hreadid=544356