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.

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

"Jammings" wrote:

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.