ExcelBanter - subtotals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/153122-subtotals.html)

swati

subtotals

I think that there is a way to copy and then paste "visible" cells while
using subtotals. Am i right? And if i am, where can i get that option from?

subtotals

depending on what you are doing
select the range in whch you are interested
edit-goto-special-visible cells
select OK
copy

"swati" wrote:

I think that there is a way to copy and then paste "visible" cells while
using subtotals. Am i right? And if i am, where can i get that option from?

swati

subtotals

thats Great!! Thanks..exactly what i wanted!!

"bj" wrote:

depending on what you are doing
select the range in whch you are interested
edit-goto-special-visible cells
select OK
copy

"swati" wrote:

I think that there is a way to copy and then paste "visible" cells while
using subtotals. Am i right? And if i am, where can i get that option from?

All times are GMT +1. The time now is 10:01 AM.