Julie,
My layout is very similar to what you had:
..........A..................B.................... ..C
1....Dept..............Person.............Amount
2....A...................Anne................20.00
3....A...................Fred...............50.00
4...Total A...................................70.00
5....B...................Steve..............100.00
6...Total B.................................100.00
7....Grand Total.........................170.00
I need to be able to add the rows because at any given time, you could have
20 names vs. 5. Again, I have about 8 different sections, like the above
layout, and I have a border around the section and also a sum formula in the
total cell.
I guess what would be ideal is to have some sort of button to add another
row or something above the total row to add rows. ??? If a macro is what I
need...how and what steps do I need to achieve this?
I appreciate your help Julie!
"JulieD" wrote:
Hi Rager
a macro basically will work for you where you can "automate" the process
without intervention ... which means that the macro has to be able to
determine WHERE to put the new row ... is there something in your workbook
that the code can use to determine this ... and
also we'll need a bit more of an idea of the structure of your worksheet ...
could you (using the same layout as i did in my example) give us an idea of
what you're worksheet's layout is. Please do not, however, attach a
workbook to your reply
Cheers
JulieD
"Rager" wrote in message
...
Thanks for the recommendation Julie...unforturnately, I have to keep the
totals column and row where they are. I've been reading some other posts
and
some people have asked similar questions as I have. Again, there is this
"macro" talk and I am not sure exactly how and exactly what actions I need
to
do to set this up. Any other suggestions from anyone??? I need help!
"JulieD" wrote:
Hi Rager
i would recommend getting rid of the total rows as long as there is a
piece
of information in your workbook to specify which group they belong to,
then
when new rows are added all you have to do is to sort by the field that
you
want to group the data on and then choose data / subtotals and Excel will
subtotal the data for you automatically
this structure will also allow you to use pivot tables, Data / Form to
enter
data into the workbook (as long as you've got less than 30 columns of
data),
and data / filter / autofilters ...........
here's an example on using data / subtotals:
.........A..................B..................... .C
1....Dept..............Person.............Amount
2....A...................Fred...............50.00
3....B...................Steve..............100.00
4....A...................Anne................20.00
is how the workbook currently appears, now i want subtotals on dept, so i
click on cell A2, choose data / sort - Dept (and while i'm there do a
secondary sort on Person)
then choose Data / Subtotal
at each change in Dept
SUM
Amount
click OK
and i end up with
.........A..................B..................... .C
1....Dept..............Person.............Amount
2....A...................Anne................20.00
3....A...................Fred...............50.00
4...Total A...................................70.00
5....B...................Steve..............100.00
6...Total B.................................100.00
7....Grand Total.........................170.00
Hope this helps
Cheers
JulieD
"Rager" wrote in message
...
Hi there,
I'm not that familiar with macros and the information I'm finding is
leading
me to believe this is what I need to be using. I currently have 8
different
sections in my worksheet and I am trying to figure out how to insert
another
blank row in these sections (before the "total" row) when needed...of
course
without interupting the rest of the worksheet. Does anyone have a
simple
solution to this? Please be very specific in the actions I need to
take
to
achieve this.
|