Copy paste Formula in Filtered Values

**kannan1847** · 01-18-2016, 05:29 AM

Dear All

I have 100 Rows in sheet 1

I need to Filter in column A with a criteria

and Put Sumifs Formula in J Column

Now My requirement is Apply Formula in Filtered Range and

Paste that as Values.

**NeedForExcel** · 01-18-2016, 11:58 PM

Try this

After you filter the data > Select the Whole filtered column (Till the last used row) where the formula is to be applied > Type in the required Formula > Commit using Ctrl+Enter

To Paste As Values, clear the AutoFilter and then Paste as values

**kannan1847** · 01-19-2016, 01:45 AM

I need to paste without clearing filter.

Copy paste Formula in Filtered Values

LinkBack

Thread Tools

Rate This Thread

Display

Copy paste Formula in Filtered Values

Re: Copy paste Formula in Filtered Values

Re: Copy paste Formula in Filtered Values

Thread Information

Users Browsing this Thread

Similar Threads

Copy and Paste while Filtered

copy paste macros

copy formula and paste for new data added and autofill.....and paste special values

VBA to copy cell (with formula) to next row and then copy and paste values in cells above

Need macro/formula for copy/paste between filtered workbooks

How to copy a value to an auto filtered column and only paste to the filtered rows in VBA

[SOLVED] Copy/Paste how to avoid the copy of formula cells w/o calc values

Bookmarks

Bookmarks

Posting Permissions