View Single Post
 
Old 11-14-2022, 06:19 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 674
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

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
Attached Files
File Type: xlsx msofficeforums49985Book12.xlsx (27.5 KB, 3 views)
Reply With Quote