Hi,
What field(s) uniquely identify a row so we know which one to update?
What fields do you want to update - is it (only) money spent? And can new
projects and associated details be added?

If some(/all) of the (first 5) fields have a limited number of values, then
use of comboboxes to select your "search" fields is one approach.

"philcud" wrote:

i have a table, 5 fields (columns) for manager name, project name, etc,

and another 144 columns giving money spent for each month
so column headers would be:-
manager name, project name, project code, category, identifier
then months going from jan-05 upwards for 12 years, so table has 149
columns and as many rows as records.


what i need is a method where a user can easily update this table
without having to find the correct row / column themselves.


how can i get a value from a user entry cell into the correct cell in
the table.