Newbie needs direction

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

Tom Ogilvy

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"
 
Top