|
|
#2
11-14-2022, 06:19 AM
|
||||
|
||||
It seems a lot of work; there is built-in functionality to take the effort out of this sort of thing. A pivot table for example (with or without slicer on the right).
If you really wanted to add columns for comments and the like you could have a short macro to copy the pivot table's values elsewhere. 2022-11-14_131545.png 
|
| 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