Copy and pasting values of filtered rows

J

Jammings

I have filtered out some rows in a spreadsheet and applied a formulae
(Vlookup) specific to these rows
I would like to have just the values in these rows when I remove the filter.

The others rows (the ones not filtered) contains other formula that I want
to maintain.

I tried copy and paste special values, But recieved an error mesage that
copy and paste area cannot overlap, among other posiible reasons.

Besides copy and pasting values one by one for each row, can this be done
for the entire sheet at one time.
 
E

Eduardo

Hi,
once filtered, hit CTRL G, special, visible cells only, OK, copy, go to
another sheet and paste it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Embed the same Excel multiple times 0
data spans multiple rows within each cell is collapsed when FILTER is used 0
Adding a big matrix in Word 2013 5
Filter, Copy and Paste 2
Formula's won't read copy / pasted data ? 2
Can't Copy and Paste when I'm using a filter List.. hmmm 1
Copy and Paste Format in filtered rows 6

Top