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 column X that contains "MEXICO." I want to extract and automatically update that data into a separate target workbook. And when I make an edit in my source workbook, I want that update to reflect in my target workbook.
Is there a formula or VBA code to complete this?
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,
