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

Copy and paste area not same in filtered mode . 8
copy and paste filtered cells 1
Filter, Copy and Paste 2
print or copy filtered rows 2
Can't Copy and Paste when I'm using a filter List.. hmmm 1
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copy and Paste Format in filtered rows 6
Filtered Mode Copying and pasting as value yield as error? 1

Top