How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items

Hi Dk, maybe compy and past special values could help you, but remember to
save an original copy with the formulas

another way is put the fonts on white collor they stay there but "invisable"

Hope this helps
regards from Brazil
Marcelo


"dk" escreveu:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items

It sounds like you should set up subtotals on the workbook. Then you can move
up and down based on the amount of detail you need. The subtotals and
grandtotals will remain in the same cells even when you hide the detail by
moving to a more general level. To put subtotals on, select the range of data
and then go to Data -- Subtotals.

"dk" wrote:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items

we are not trying to hide cells we would like to delete it all the way just
keep the subtotatals?
also please advise how subtotals will work?

"RJ" wrote:

It sounds like you should set up subtotals on the workbook. Then you can move
up and down based on the amount of detail you need. The subtotals and
grandtotals will remain in the same cells even when you hide the detail by
moving to a more general level. To put subtotals on, select the range of data
and then go to Data -- Subtotals.

"dk" wrote:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items

I guess the best explanation of subtotals would be from Microsoft itself.
Here is a link to their literature.
http://office.microsoft.com/en-us/as...097981033.aspx

Basically, you choose terms to group by (sounds like customers in your case)
and apply a sum or other mathematical function at this level. A subtotal
wiill appear below the grouping and a grand total at the end (which is the
sum of the subtotals.) After you have applied subtotals to your worksheet you
can change which level of detail you would like to show. You could show all
of the data which would be all of the individual bills the customer has, or
you could show subtotals which would be each individual customers totals, or
a grand total which would be the sum of all the customers. Hopefully this
helps some.

"dk" wrote:

we are not trying to hide cells we would like to delete it all the way just
keep the subtotatals?
also please advise how subtotals will work?

"RJ" wrote:

It sounds like you should set up subtotals on the workbook. Then you can move
up and down based on the amount of detail you need. The subtotals and
grandtotals will remain in the same cells even when you hide the detail by
moving to a more general level. To put subtotals on, select the range of data
and then go to Data -- Subtotals.

"dk" wrote:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items

We read this article will not work because every cell has date only rows that
have a new date value not rows which equal the same date
also we need the subtotal figures in different workbook not it the same

"RJ" wrote:

I guess the best explanation of subtotals would be from Microsoft itself.
Here is a link to their literature.
http://office.microsoft.com/en-us/as...097981033.aspx

Basically, you choose terms to group by (sounds like customers in your case)
and apply a sum or other mathematical function at this level. A subtotal
wiill appear below the grouping and a grand total at the end (which is the
sum of the subtotals.) After you have applied subtotals to your worksheet you
can change which level of detail you would like to show. You could show all
of the data which would be all of the individual bills the customer has, or
you could show subtotals which would be each individual customers totals, or
a grand total which would be the sum of all the customers. Hopefully this
helps some.

"dk" wrote:

we are not trying to hide cells we would like to delete it all the way just
keep the subtotatals?
also please advise how subtotals will work?

"RJ" wrote:

It sounds like you should set up subtotals on the workbook. Then you can move
up and down based on the amount of detail you need. The subtotals and
grandtotals will remain in the same cells even when you hide the detail by
moving to a more general level. To put subtotals on, select the range of data
and then go to Data -- Subtotals.

"dk" wrote:

How can we delete rows but the total balance shall still remain ex: we have a
customer that has 10 bills and we want to make a invoice with his total
balance without having the rows of description and dates etc.? or exampled
how we much we earned this month without after deleting detailed info. we
have alot of workbook linked to the totals but doesn't need the detailed items