| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 74983 | 2006-12-12 06:39:00 | change cell refernces in MS excel 2003 | snowman88 (11613) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 506197 | 2006-12-12 06:39:00 | Hi there I daily update a large excell spreadsheet thgat contains references to other worksheets in the spreadsheet. The refernces are are all 1 column down at a time (e.g. from ='CH Data'!K107 to ='CH Data'!K108. Is there a simple way to automate this? Thanks in advance Sno |
snowman88 (11613) | ||
| 506198 | 2006-12-13 02:21:00 | Hi Sno Try this formula; =INDEX('CH Data'!K:K,MATCH(9.99999999999999E+307,'CH Data'!K:K)) This should return the last value in column K in the worksheet CH Data. Cheers. Roger |
RogerRamjet (7055) | ||
| 506199 | 2006-12-13 07:53:00 | sweet, thanks. I will give that a go. At least it wil give me something to start on. Cheers Sno |
snowman88 (11613) | ||
| 1 | |||||