copy and paste after filtering rows
I can not believe I cant do this and am sure I have asked before which makes it worse.
I have filtered the rows in my spread sheet. In the visible cells in column M after row 1 I have a vlookup formula which returns a value. I want to copy from the next visible row in column M after row 1 which is the header and paste not the formula but the value into the same row in column K.
Not each cell in column M will have a value as the vlookup may not have found a match.
How do I do this?
Thank you
Smiler44
I can not believe I cant do this and am sure I have asked before which makes it worse.
I have filtered the rows in my spread sheet. In the visible cells in column M after row 1 I have a vlookup formula which returns a value. I want to copy from the next visible row in column M after row 1 which is the header and paste not the formula but the value into the same row in column K.
Not each cell in column M will have a value as the vlookup may not have found a match.
How do I do this?
Thank you
Smiler44
Last edited: