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...
I have a spreadsheet into which I routinely pull rows from two external sheets. I do it solely by means of a FILTER function. No VBA needed. It is necessary that the external sheets be open when I'm doing it, but other than that, the FILTER function, which contains selection criteria, does all the work.
Have you considered that possibility?
- 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.
ThanksJust 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
