How to create several lists

[IlkaAntonie]

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]

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]

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

 

[Debra Dalgleish]

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