Building a better Mouse Trap
 

-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

Building a better Mouse Trap
 

did ;you try using vlookup formula in the clients' sheets


"oberon.black"
wrote in message
news:oberon.black.1v9yuc_1126577127.0887@excelforu m-nospam.com...

-Background-
I have a workbook with several worksheets in it. The master worksheet
(the worksheet used most) is what I use to enter client names and
numeric records into. When I update client information I update it for
all the clients that I have. So if it is daily income I do that for
each client on the master worksheet. Then I have to go to each of the
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 the
following:
1. pull a list of client names from the sheet. so that when I open
the userform the client names will be added to the form from the
spreadsheet.

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

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

-Problem-
This is a huge task I think since the client list gets updated from
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 think
simple because of referencing.


-Solutions-
I have none hoping someone out there has a huge brain on them. This is
going to be a every exciting undertaking for me and I need alots of help
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.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=467001