Newbie needs direction

  • Thread starter Thread starter FilterXG
  • Start date Start date
F

FilterXG

I've done very little Excel Programming so I don't know if this is
possible to do. If it is, I would appreciate some reference to a
site, post or book that would help me do it.

1) I want to be able to copy information to one row below the bottom
row of the sheet.
2) I want to be able to automatically extend sum formulas when
information is entered in a cell. This cell "floats" and will always
be one below the last row, on the same same row which the formula is
to be extended to.
 
to get to the bottom of a set of data

assume column A and data is contiguous (no embedded blank cells) with data
starting in A1
Data must be in A1 and A2 (so this would need to be checked explicitely)

set rng = Cells(1,1).End(xldown).Offset(1,0)

if not other data is below, you can come up from the bottom

set rng = Cells(rows.count,1).End(xlup).Offset(1,0)

This assumes data in A1 (this would need to be checked).

In Excel 2000 and later, this is an option in Tools=>Options=>Edit Tab
"Extend List formats and Formulas"
 
Back
Top