Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie needs direction
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie needs direction
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" -- Regards, Tom Ogilvy FilterXG wrote in message om... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Direction | New Users to Excel | |||
Need direction | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
Direction | Excel Discussion (Misc queries) | |||
I need direction | Excel Discussion (Misc queries) |