On Sat, 2 Oct 2004 12:21:55 +0100, "Bob Phillips"
wrote:

What is the worksheet data like, and where in the form do you want to put
it?

Hi,


What I have is data in columns A - L. The data is in the form of text,
e.g. A1, B1, C1, will have text, D1 will have a date (dd/mmm/yy -
hopefully, but that will be a later question!) etc.

All the cells in column A will have an unique entry - something along
the lines of BDE001 or WNJ034. At some point I will need to add data,
again in the form of text and dates, to columns M - W of a particular
row. E.g. I will want to make my form appear via a macro and either
add new data to a new row, or alternatively add data to an already
existing row - say row 12 which is uniquely identified by having
BDE001 in cell A12. I see now that it isn't necessary to have the form
show what has already been entered in row 12, columns A - L, but I do
want to be able to use maybe a combo box and select BDE001, enter the
additional data into the form and have the form write this to cells M
- W of row 12.

Possibly not the clearest way of explaining what I'm hoping to
achieve, but can't think of a better way of describing it.

--
Cheers

Peter

Remove the INVALID to reply