PasteInVisible

• By Ctrl+C, excel copies only visible cells to the clipboard. It excludes cells in rows or columns that are filtered, hidden, or grouped.
• By Ctrl+V, excel pastes cells from the clipboard into consecutive rows and columns not only visible but also those that are filtered, hidden or grouped. Note:
• To paste cells from clipboard into only visible cells use this AddIn.
• Shift+Ctr+K is useful when consolidating parts of a table into a whole table.

Usage:

• Ctrl+C - copy consecutive (CR) or fragmented by hidding, grouping or filtering range (FR) of visible cells to clipboard (CB)
• Shift+Ctr+C - convert the selected range (SR) from CR or FR and save it (RR). Look SelectVisible, Copy visible cells only
• Ctrl+D - replicate the first row of SR to the whole SR including rows hidden by grouping or filters
• Shift+Ctr+C Ctrl+D - replicate the first row of SR to the entire RR, not including rows hidden by grouping or filters
• Ctrl+R - replicate the first column of SR to the entire SR including columns hidden by grouping
• Shift+Ctr+C Ctrl+R - replicate the first column of SR to the entire RR, not including columns hidden by grouping
• If FR is in CB Ctrl+V - inserts from it into SR including cells hidden by grouping or filtering values and formats
• If CR is in CB Ctrl + V - pastes from it into SR including cells hidden by grouping or filtering formulas and formats
• Ctrl+C Ctrl+Alt+V - pastes CR or FR from CB to SD including cells hidden by grouping or filtering with choice of insertion type
• Ctrl+C Shift+Ctr+X - Paste RR into SR without extending borders, not including cells hidden by grouping or filters. Look PasteX
• Ctrl+C Shift+Ctr+V - Paste RR into SR without extending borders and pasting values, not including cells hidden by grouping or filters. Look PasteV
• Shift+Ctr+K - same as in Shift+Ctr+V, but only empty cells (EC) are replaced and only if all key cells (not EC) are equal. Look PasteK

Installation:

• Alt+F8 SaveAsAddIn Run - Save and set ThisWorkbook as AddIn. Look SaveAsAddIn

Сonsolidation example:

• There is a table Whole that needs to be filled in by different parts (sections, branches, subdivisions)
• Red Part1&2 - the result of filling in the table Whole
• Blue Part3 - the result of filling the table Whole
• If parts in different books open them,
• filter Whole by Part<3, filter Part1&2 by Part<3, select from Part1&2 Ctrl+C, paste into Whole Shift+Ctrl+K,
• filter Whole by Part=3, filter Part3 by Part=3, select from Part3 Ctrl+C paste into Whole Shift+Ctrl+K

Использование, установка, пример консолидации

Credits

• Fastest Method to Copy Large Number of Values in Excel VBA
• How do you take a vba addin and make an installer