On Fri, 23 May 2008 09:43:43 -0400 Jerry Feldman <[EMAIL PROTECTED]> wrote:
> I have a spreadsheet whose depth depends on an actuarial table. So, for > an example I have a sheet that extends for 10 years, with each row > representing a month: > Row Date period time > 11 5/23/2008 1 0 > 12 6/23/2008 1 2 > 122 5/23/2008 11 120 > > So, lets say in cell A1, I have the number of years. Is there a > programmatic way that if the value in cell A1 changes, the spreadsheet > can be extended or contracted. So, in a very simple pseudocode: > calculate last row based on A1; If A1 contains 15, the > last row would be 182. > copy row 12. > paste into rows 13 through 182. > > The reason I ask is that the existing spreadsheet currently has about > 80 columns in use. Certainly there needs to be a bit more > intelligence, such as deleting the contents of rows in the case of > reducing the number in A1. But, I'm just looking for some ideas. I'm > good at C++ code, but a novice on spreadsheets even though I bought my > first Visicalc directly from Dan Bricklin. One addition to this is that we can set up a maximum of 150 years. -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
