-Background-
I have a workbook with several worksheets in it. The master workshee
(the worksheet used most) is what I use to enter client names an
numeric records into. When I update client information I update it fo
all the clients that I have. So if it is daily income I do that fo
each client on the master worksheet. Then I have to go to each of th
clients individual worksheets and update the figures there as well.
This is very time consuming.

-Need-
I want to know if it is possible to create a userform that will do th
following:
1. pull a list of client names from the sheet. so that when I ope
the userform the client names will be added to the form from th
spreadsheet.

2. will add a textbox next to the client name that will allow me t
insert my figures into.

3. upon cmdbutton will empty the figures into the master sheet an
on to each of the individual client sheets.

-Problem-
This is a huge task I think since the client list gets updated fro
time to time by either adding or removing client names.

Dumping the figures into the master workbook should be fairly simple
but dumping to the personal sheets would be difficult I would thin
simple because of referencing.


-Solutions-
I have none hoping someone out there has a huge brain on them. This i
going to be a every exciting undertaking for me and I need alots of hel
since I am not a programmer and could not even tell you what 'DIM
means.

I look forward to getting lots of help on this project.

Let your ideas come forth

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46700