Forum Discussion
MACRO TO COPY DATA FROM ONE FILE TO ANOTHER AS VALUE
I'm not a believer in macros or VBA routines, except as a last resort. So here's what could be a different way to bring that data across, making use of the recently available FILTER dynamic array function. I added a criterion column to your leafnew sheet, to identify the rows in question.
You don't describe how this request of yours fits into a bigger picture....and I don't pretend that this could be a solution for all situations, so it may be that a macro is needed, and I'll let others who are good at that chime in. My point is that a fairly simple formula can bring over those rows--I only wrote two formulas...the results "spill" down into adjacent rows, however many are required. No need to copy the formula, no need to copy and paste....
So I just wanted to make sure you're aware of these new functions.
Thanks .