Automating some tasks
I have a table in which I record some daily figures. I'd like, once I
input the figures, a row to be automatically added to another worksheet (in the same workbook) recording a calculation on those figures. I know I could paste the formula in each cell in many rows of the worksheet on which the calculation is to appear but I'm sure I must be able to automate it - and if I don't automate it I'm sure I'll eventually add more rows to the first sheet than there are rows with the formula on the calculation sheet - and also, when there are lots of formulae in a worksheet it can slow down recalculation. Justin. -- Justin C by the sea. |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com