Hi,

I have a spreadsheet that has data dumped from another program.
Each day I format the refreshed data. That means I:

Insert blank rows to divide parts
Type in bold TOTAL under the several lines for that part
Hit ALT+ to TOTAL the count of parts
Hit ALT+ to TOTAL the amount for parts
Then go to the next section and do the same thing over again!

The number of parts varied each day, so I can not use a given number of lines.

Any clue if there is a solution for this?
Thank you.

Why not use the 'SubTotal' option from the Data menu item for EXCEL 2003 and
lower or the Data | Outline | Subtotal menu for EXCEL 2007+?
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"DTTODGG" wrote:

> Hi,
>
> I have a spreadsheet that has data dumped from another program.
> Each day I format the refreshed data. That means I:
>
> Insert blank rows to divide parts
> Type in bold TOTAL under the several lines for that part
> Hit ALT+ to TOTAL the count of parts
> Hit ALT+ to TOTAL the amount for parts
> Then go to the next section and do the same thing over again!
>
> The number of parts varied each day, so I can not use a given number of lines.
>
> Any clue if there is a solution for this?
> Thank you.

Gary,

I would love to use SUBTOTAL, but, I have to manually go through and make
the divisions, so subtotal would not work.

I was hoping to make a little icon that when I clicked on it, it would:
Write TOTAL in bold and right justified in the cell
Then go to the next cell to the right and do an ALT+ for the count total
Then go to the next cell to the right and do an ALT+ for the dollar total

Got any ideas?

"Gary Brown" wrote:

> Why not use the 'SubTotal' option from the Data menu item for EXCEL 2003 and
> lower or the Data | Outline | Subtotal menu for EXCEL 2007+?
> --
> Hope this helps.
> If it does, please click the Yes button.
> Thanks in advance for your feedback.
> Gary Brown
>
>
>
> "DTTODGG" wrote:
>
> > Hi,
> >
> > I have a spreadsheet that has data dumped from another program.
> > Each day I format the refreshed data. That means I:
> >
> > Insert blank rows to divide parts
> > Type in bold TOTAL under the several lines for that part
> > Hit ALT+ to TOTAL the count of parts
> > Hit ALT+ to TOTAL the amount for parts
> > Then go to the next section and do the same thing over again!
> >
> > The number of parts varied each day, so I can not use a given number of lines.
> >
> > Any clue if there is a solution for this?
> > Thank you.

I can not get away from the manual sorting, but after that, I would like to
write the TOTAL and calculate the amounts thru some macro or some code.

"DTTODGG" wrote:

> Gary,
>
> I would love to use SUBTOTAL, but, I have to manually go through and make
> the divisions, so subtotal would not work.
>
> I was hoping to make a little icon that when I clicked on it, it would:
> Write TOTAL in bold and right justified in the cell
> Then go to the next cell to the right and do an ALT+ for the count total
> Then go to the next cell to the right and do an ALT+ for the dollar total
>
> Got any ideas?
>
> "Gary Brown" wrote:
>
> > Why not use the 'SubTotal' option from the Data menu item for EXCEL 2003 and
> > lower or the Data | Outline | Subtotal menu for EXCEL 2007+?
> > --
> > Hope this helps.
> > If it does, please click the Yes button.
> > Thanks in advance for your feedback.
> > Gary Brown
> >
> >
> >
> > "DTTODGG" wrote:
> >
> > > Hi,
> > >
> > > I have a spreadsheet that has data dumped from another program.
> > > Each day I format the refreshed data. That means I:
> > >
> > > Insert blank rows to divide parts
> > > Type in bold TOTAL under the several lines for that part
> > > Hit ALT+ to TOTAL the count of parts
> > > Hit ALT+ to TOTAL the amount for parts
> > > Then go to the next section and do the same thing over again!
> > >
> > > The number of parts varied each day, so I can not use a given number of lines.
> > >
> > > Any clue if there is a solution for this?
> > > Thank you.