Forum Discussion
Compare, copy and paste from an external worksheet.
I'm trying to perform a search on an external worksheet then copy the lines with matching data to paste in the original worksheet. The code I've come up with is a bit of a mess as I've tried mult...
It's all part of a larger interface, pulling data from different sheets and workbooks to a central point. I haven't considered using a filter but I'll look into it.
Thanks
Thanks
Just to make sure we're on the same page here, I wasn't suggesting using "a filter"--which might mean the button on the data tool bar--but rather, the FILTER function. There is a link in that earlier message to a resource that describes the function.
There's also a very useful and informative video that Microsoft used to introduce the function when it was new.
- I understood about the function. Sorry - it was a rushed reply as I'm doing too many things at once! Thanks for the suggestion and the video. I'll look into it and see if it'll work for me.
Thanks- No problem, I just wanted to be sure we were clear...