software

Other than copying formulas manually to the next row of empty cells, can a
function within the preceding data entry cell do the work upon completion,
lt;entergt;, or auto summing?

All cells within the range will have entries, so no isolated empty cells are
present to mess up the integrity. These are scientific, engineering functions
with no limit to range of entries.

Having searched through several manuals and this forum, I'm not too
optimistic for a solution, but keep trying...

Thanks,
--
Bruce McC


You can create a macro that does this.

Otherwise, if you double click on the lower right corner of a selected
cell (or range of cells) to be filled downward that works too.

I don't know of any function that you can type in a cell to make it
autofill automatically or act as the ENTER key.

If you would like to create a macro and need help let me know and give
a little more details and I'll see what I can do.

Bruce Wrote:
gt; Other than copying formulas manually to the next row of empty cells, can
gt; a
gt; function within the preceding data entry cell do the work upon
gt; completion,
gt; lt;entergt;, or auto summing?
gt;
gt; All cells within the range will have entries, so no isolated empty
gt; cells are
gt; present to mess up the integrity. These are scientific, engineering
gt; functions
gt; with no limit to range of entries.
gt;
gt; Having searched through several manuals and this forum, I'm not too
gt; optimistic for a solution, but keep trying...
gt;
gt; Thanks,
gt; --
gt; Bruce McC--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: www.excelforum.com/member.php...oamp;userid=33371
View this thread: www.excelforum.com/showthread...hreadid=534546Thanks, Ikaabod. I was resigned to accepting your answer. All those
quot;explicativequot; columns after the quot;0quot; columns just don't look very clean. It
would be nice to insert the column title, instead.

I wanted to avoid macros or VBA in this workbook. Many of the people that
would use the spreadsheet are recreational users and, like me, would balk at
casually opening something with nasty warnings of viruses. I've been
free-time studying Excel for a couple months. lt;Undogt; is my favorite command
so far.
--
Bruce McCquot;Ikaabodquot; wrote:

gt;
gt; You can create a macro that does this.
gt;
gt; Otherwise, if you double click on the lower right corner of a selected
gt; cell (or range of cells) to be filled downward that works too.
gt;
gt; I don't know of any function that you can type in a cell to make it
gt; autofill automatically or act as the ENTER key.
gt;
gt; If you would like to create a macro and need help let me know and give
gt; a little more details and I'll see what I can do.
gt;
gt; Bruce Wrote:
gt; gt; Other than copying formulas manually to the next row of empty cells, can
gt; gt; a
gt; gt; function within the preceding data entry cell do the work upon
gt; gt; completion,
gt; gt; lt;entergt;, or auto summing?
gt; gt;
gt; gt; All cells within the range will have entries, so no isolated empty
gt; gt; cells are
gt; gt; present to mess up the integrity. These are scientific, engineering
gt; gt; functions
gt; gt; with no limit to range of entries.
gt; gt;
gt; gt; Having searched through several manuals and this forum, I'm not too
gt; gt; optimistic for a solution, but keep trying...
gt; gt;
gt; gt; Thanks,
gt; gt; --
gt; gt; Bruce McC
gt;
gt;
gt; --
gt; Ikaabod
gt; ------------------------------------------------------------------------
gt; Ikaabod's Profile: www.excelforum.com/member.php...oamp;userid=33371
gt; View this thread: www.excelforum.com/showthread...hreadid=534546
gt;
gt;