M Mark Jul 15, 2008 #1 After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal
B Bernie Deitrick Jul 15, 2008 #2 Mark, Select the cells, then use Edit / Go to... Special Visible Cells Only, OK, then copy and paste. HTH, Bernie MS Excel MVP
Mark, Select the cells, then use Edit / Go to... Special Visible Cells Only, OK, then copy and paste. HTH, Bernie MS Excel MVP
