View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 110
Default 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