Automatically copy formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple ledger spreadsheet and I would like to add a balance column.
I have no idea how long this spreadsheet will get, but I don’t want to copy
the formula down thousands of cells because I don’t want to print hundreds of
blank sheets.

I’ve thought of two solutions, but can’t figure either out; how could I set
the sheet to automatically copy the balance formula down a line when data is
entered on a line OR set the sheet to only print lines that have data on them.

I don’t want to set print areas because the user of this sheet is not very
computer literate and will likely end up printing 200 pages…

Thanks.
 
Hi als,

Assuming your data is in Col's A....H and your balance
formula is in the Col I...and that Col H will have an
entry in it when rows are filled with data, even it's
a "0". Then by entering your formula in the first row of
Col I, selecting that cell and double clicking on the
lower right hand corner, the formula in Col I will fill to
the last entry of Col H, again, assuming there are no
blanks in Col H. That will only fill to what is required
for the immediate balance.

HTH,

Don
 
Hi Als,
You might take a look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
both at the macro for inserting rows, but also at the macro
for a Change Event when the date is inserted (won't pick
up Ctrl+; though.
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#ChangeEvent

I doubt with that many columns that Extend functions and formatting
would work for you but you might also check this topic in the above anyway.
Extended Formats and Formulas (#extended)


Hi als,

Assuming your data is in Col's A....H and your balance
formula is in the Col I...and that Col H will have an
entry in it when rows are filled with data, even it's
a "0". Then by entering your formula in the first row of
Col I, selecting that cell and double clicking on the
lower right hand corner, the formula in Col I will fill to
the last entry of Col H, again, assuming there are no
blanks in Col H. That will only fill to what is required
for the immediate balance.

HTH,

Don
 
Back
Top