Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
missing data from table | Excel Discussion (Misc queries) | |||
missing data from table | Excel Discussion (Misc queries) | |||
changing proportion of chart and data table | Charts and Charting in Excel |