| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104204 | 2009-10-20 00:09:00 | Excel Question-can anyone help? | smurf (6545) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 822241 | 2009-10-21 08:48:00 | Well guys thank you for your help I have managed to get it to work to a point. Obviously the reference cell that you point to in the formula will change with the next transactional balance on each sheet. Is there any way that I can get it to recognise that reference cell change automatically or will I have to manually do it? | smurf (6545) | ||
| 822242 | 2009-10-21 09:21:00 | Is there any way that I can get it to recognise that reference cell change automatically or will I have to manually do it? I think that if you name the cells you are adding instead of using cell references it should work. |
johnd (85) | ||
| 822243 | 2009-10-21 09:37:00 | Not sure I understand what you mean eg at the moment say the balances are in column F and the balance at the moment is say F27, the next one will be F28 and so on down the column each time I revise the balance. How would I express that in the formula? | smurf (6545) | ||
| 822244 | 2009-10-21 09:38:00 | Well guys thank you for your help I have managed to get it to work to a point. Obviously the reference cell that you point to in the formula will change with the next transactional balance on each sheet. Is there any way that I can get it to recognise that reference cell change automatically or will I have to manually do it? So can I take it that each sheet grows in a verticle direction on a regular basis? If so then figure the maximum number of rows any particular sheet is likely to grow to and use the bottom row to contain the balance. That way you can use the absolute method as already decribed. Possibly the whole workbook needs redesigning anyway. |
Sweep (90) | ||
| 822245 | 2009-10-21 09:46:00 | Hi Sweep Yes, each sheet grows in a vertical way on a regular basis. Therefore the balance updates with each entry. I guess you are right in that the workbook needs redesigning but that's what you get when a very raw amateur starts out playing :) |
smurf (6545) | ||
| 822246 | 2009-10-21 10:03:00 | Sweep....it is on its way....Thanks a zillion :) | smurf (6545) | ||
| 1 2 | |||||