Last version published: 06/05/2021 17:31
Publication number: ELQ-74590-2
View all versions & Certificate
Excel ‘Conditional Paste’ Add-in
A handy utility, a ‘must have’ for FINANCIAL MODELLERS and EXCEL DESIGNERS of dashboards and presentation materials.
Michael Martin offers you this Best Practice for free!
download for free
Add to bookmarks
Save time when duplicating (a) extensive columns with lots of SUMS/SUBTOTALS or (b) highly formatted presentation material, especially with modified row heights and column widths.
When working with a dashboard, presentation material or a periodic financial model.
As with most tools, this tool doesn’t work where the source range includes any merged-cell areas: these would need to be copied/pasted separately.
Write a review
People using this Best Practice also downloaded
De-select Active Cell from a selection with a VBA MacroDe-select a cell from a collection of selected cells/ranges in an Excel worksheet238add_shopping_cart
Excel Column Filter toolsThree quick COLUMN FILTER utilities for Excel data tables (now also works with post-Excel 2007 ListObject 'Tables').59add_shopping_cart
Any questions on Excel ‘Conditional Paste’ Add-in?
The user community and author are here to help. Go ahead!