I'm not sure if this can be done, but I am sure that you experts will
tell me if it can't.
I handle the financial affairs for a number of clients and keep my own
records of their current bank balances on separate Excel Sheets within
the same file.
On Sheet One, I have a list of all the clients' names and I have to
enter an amount of money against each client. Sheet No. 2 and onwards
will represent a Bank Statement for each of the clients.
Am I able to enter a figure on Sheet 1 against a particular client's
name and have it automatically inputted onto their 'statement' sheet
*below* the last entry that was made?
The problem I'm coming up against is in making any subsequent entries
appear on the statement in the *_line_below_*. (i.e. getting the script
to go to the client's personal page find the last entry and drop down a
line)
Too complicated?

Please bear in mind also that I am not an expert in VB.

Many thanks.


--
Fotoman
------------------------------------------------------------------------
Fotoman's Profile: http://www.excelforum.com/member.php...o&userid=30729
View this thread: http://www.excelforum.com/showthread...hreadid=503958