Forum Discussion
barkingsquirrel
Dec 19, 2023Copper Contributor
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...
barkingsquirrel
Dec 20, 2023Copper Contributor
I'm still having difficulty narrowing down which function I would use to transfer that filtered data. COUNTIF?
mathetes
Dec 20, 2023Gold Contributor
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,