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.
--
--
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
