Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1110
Copy Summary row with / without detail rows
posted

Hi

I would like to copy Summary Row into clipboard (with / without column headers). Also want to copy selected summary and detail rows in to clipboard.

Attached file has code & image (result that I am looking for).  

Btw... this code had showing cell borders for summary cells.  (might be helpful to others)

1. Run the code.
2. Select "Sum" for ID column.

3. Group by "Abbreviation" column.

4. I want to copy First Summary row (i.e. "0Too Looooooooooong" group by row).

5. I also want to copy Summary row & Its details rows (i.e. 2 rows) 

Looks like summary row wont allow to select as regular data row to copy.

Is there a way to copy summary row (with deail rows) ? Like providing context manu to copy etc.

Can you modify the code and upload back (if we have any solution).

Thanks

copySummary.zip