|
|
#6
11-15-2022, 04:03 AM
|
||||
|
||||
I would put the comments with the source data, then include the comments in the pivot. See attached. The comments will remain associated (move) with the data on refreshing.
re:"Also I have formula below that table that Total Value Less Diff Value, So this will stay as it is or I have to Add when refresh data?" I see no Diff Value anywhere! Attach a file where we can see this calculation. It's likely, that if the Diff Value is in the source data, it too can also be included in the pivot table. 
|
| Tags |
| copy data by month, copy data to name ranges, copy data usinf inputbox |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Table Merge _ Auto Delete Blank Lines (without Data)
|
Alex1s85 | Mail Merge | 7 | 05-04-2020 05:12 AM |
| Copy Data from different areas in a worksheet into a Table | Josh1012 | Excel Programming | 2 | 09-20-2018 01:51 AM |
| copy data table from pdf to excel | DIMI | Excel | 1 | 07-10-2018 11:40 PM |
|
Delete table if cell has data
|
So New2 This | Word VBA | 1 | 05-06-2013 09:00 PM |
|
Copy/Paste/Delete Table & Section etc.
|
flds | Word VBA | 40 | 07-16-2011 07:34 AM |
Windows 10 
Office 2019
Threaded Mode