copy/paste sheet with subtotal to another workbook
Nov 9, 2010 · I have a spreasheet with subtotals that needs to be copy/pasted into a new woorkbook. I see that when copy/pasted within the same workbook to another tab it retains the …
excel 365 - subtotal and median - Microsoft Community
Feb 18, 2016 · Please add a median calculation to the subtotal feature. Thank you.
Excel 365 Multilevel Subtotal Problem - Microsoft Community
Sep 7, 2015 · I've found a problem in Excel's Subtotal outline feature which occurs in a very specific set of conditions. I've prepared the video below to demonstrate the problem, explain …
Importing Data to Excel and Table Formats - Microsoft Community
Jun 23, 2025 · The data imports into Excel as a table format. However, I need to apply the subtotal function and then create a formula within Conditional Formatting to apply a specific …
subtotal rows hidden by a macro - Microsoft Community
Mar 23, 2020 · Still works great, the subtotal adjusts to the new count correctly. However when I engage another macro to "unhide" those hidden rows the Subtotal formula does not update for …
How to reference a different sheet depending on a result with a …
Jul 3, 2025 · Hello, Please bare with me on this I am not a pro, just a hobbyist. I am using a lookup function to find a value on a table that is a result of input values. =VLOOKUP …
How do I take YYYY/MM/DD & Convert to DD.MM.YYYY BUT then …
Apr 13, 2024 · I can convert a date from 2024/03/20 to the required format of 20.03.2024 I bet that is the first mistake and the basic problem! There is no need to convert a date in Excel with any …
Excelのグラフでメモリの境界値が表示されない - Microsoft Q&A
Excel で軸のオプションに境界値の設定項目が無いのですね。 手元の環境では表示されました。 Excel バージョン2203 (ビルド 15028.20204 クイック実行) Windows 10 バージョン 21H2 …
Excel 2010 vba insert subtotal - Microsoft Community
Jul 10, 2025 · Excel 2010 vba insert subtotal I am using the following macro to insert the subtotal...but found out this does not update the subtotal whenever the data in the table is …
共有で使用しているファイルが時々破損 (？)する - Microsoft Q&A
ロックされた質問。 この質問は、Microsoft サポート コミュニティから移行されました。 役に立つかどうかに投票することはできますが、コメントの追加、質問への返信やフォローはでき …