Forum Discussion
I need help transferring and automatically updating data between workbooks
I'm an Excel newb who's new to the world of VBA and formulas. I have a massive workbook with 8,000+ rows of filterable data. In my source workbook, I want to extract every row associated with co...
Take a look at the FILTER function. Here's one text-based resource that describes it.
And here's' a YouTube video from Microsoft used when first introducing the function a couple of years ago.
I'm still having difficulty narrowing down which function I would use to transfer that filtered data. COUNTIF?
FILTER by itself can transfer data from one sheet to another.
Is it possible for you to post a copy of the workbook(s) you're working with? On OneDrive or GoogleDrive, with a link pasted here that grants access, please. Just anonymize any confidential or personal info,