subtotal columns

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

Hi, I am having a little problem, can anybody help? I have a colum
with a list of names, some of which are repeated several times. I use
the subtotal function to group the repeated names (dont known if tha
is the best way). Now, I created a columns next to it where I a
supposed to input if the person pays with cash or credit. The questio
is: Once I hide the subtotals, only to show one entry per person, i
there a way that I can put 'cash' in one entry and make is cascate dow
to its subentries automatically? Thanks.

Regards,

Mar
 
Mark,

You should be able to enter your value in the first cell for that name, then
after hitting enter, reselect that cell and hover your mouse over the little
black box at the lower right side of the cell selection indicator. When your
cursor changes to a black cross, double click. That will fill down to match
your name set.

HTH,
Bernie
MS Excel MVP
 
Back
Top