Hi everyone. :)

I'm sure this is something very simple that I'm overlooking, but I
can't come up with a good solution after hours of playing around. I'm
hoping someone with more skill than I can help me out. :)

I'm trying to create sort of an ongoing checkbook register type of
sheet. I have about 8 columns per row, some columns are plain text,
some numbers, and 3 or 4 of them are calculated/forumla columns based
on other columns in the row.

What I want to be able to do is insert a new record (row) below the
existing records every so often. Catch is that I want the new rows to
be formatted like all the previous rows (borders, patterns, etc) and
carry the same formulas as the previous rows.

I know I could just have like a thousand pre-formatted rows from the
beginning that I just fill in, but I'd rather not do that because I
only want Excel to print/show the neccessary amount of pages and not a
bunch of blank formatted rows that I've not yet filled in. And I don't
want my totals row (the row at the very end that sums up some of my
columns) to be like on page 12 when my records only go up to page 3.
;)

I hope that makes sense; if not, please ask and I'll try to explain
better.

Thanks in advance to anyone who could help me out. :)


--
Namras
------------------------------------------------------------------------
Namras's Profile: http://www.excelforum.com/member.php...o&userid=29873
View this thread: http://www.excelforum.com/showthread...hreadid=495769