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

Instead of separate sheets, you could keep all the data on the master
sheet, then use an AutoFilter and pivot table to display individual
clients or their totals.

However, you could use programming to create client sheets. There's a
sample workbook on my web site, that sends data to individual sheets
from a table on the master sheet

http://www.contextures.com/excelfiles.html#Filter

under the heading 'Update Sheets from Master'


IlkaAntonie wrote:
> 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
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Hi Debra,

Thanks for the info. I opted for your AutoFilter and pivot tabl
suggestion and they do everything I need. It works like a charm.

Thanks for your help.

Ilk

--
IlkaAntoni
-----------------------------------------------------------------------
IlkaAntonie's Profile: http://www.excelforum.com/member.php...fo&userid=3467
View this thread: http://www.excelforum.com/showthread.php?threadid=54435

You're welcome, and thanks for letting me know which solution you
decided to use.

IlkaAntonie wrote:
> Hi Debra,
>
> Thanks for the info. I opted for your AutoFilter and pivot table
> suggestion and they do everything I need. It works like a charm.
>
> Thanks for your help.
>
> Ilka
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html