Skip to content
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
add-in
form
media
module
resources
LICENSE.md
README.md

README.md

Paste in Filter Macro Download

Short description:

Paste in Filter allows you to paste unfiltered content into a filterd area by skipping all filtered (hidden) rows.

Features:

  • Choose the worksheet and cell you want to paste into
  • Select between 3 different modes for copying

Demo (Video):

Installation:

  • Open Excel
  • Goto File -> Options -> Add-ins
  • Click on Go... next to "Manage: Excel Add-ins" at the bottom
  • Click on Browse...
  • Paste the *.xla-file from the download in the folder which just opened
  • Select the *.xla-file and click "OK"
  • Click "OK" again on the Add-ins window

How to use:

  • Open Excel and select the area which should be copied. (Copying itself is not necessary)
  • Goto Add-ins in the tab-menu
  • Click on Paste in Filter
  • Select the worksheet
  • Enter the row and column (Example: E 7)
  • Select a mode for copying:
Mode Explanation
Relative formula Copy and paste the formula relative (will change the cell references inside the formula relative to the new area)
Absolute formula Copy and paste the formula absolute (won't change the cell references)
Value Copy and paste values only
You can’t perform that action at this time.