I have an Excel file (we'll call this file 1) with specific data that needs to be transferred into another Excel file (we'll call file 2). File 2 is large and contains many more columns and rows not included in file 1. I've tried to filter and match the columns and rows in both files, select the data I need from file 1, and copy and paste it into file 2. Since there are hidden columns and rows in file 2, the pasted data populates in sequential order (including the hidden cells) instead of populating only in the filtered cells.

Is there is a faster way to import the information into the filtered cells?

Thank you for your time!