New to VBA - Want to clean up my code and have it run faster

I have just started out trying to learn VBA code. Essentially what I want this code to do it is open the source workbook, then find the corresponding month (based on a drop down in a cell in the destination workbook), then go through the source workbook and match up the line item from the destination workbook, and paste the value in the correct month in the destination workbook. I currently have it so that it will just loop through each line item in the destination workbook and match it from the source workbook. However, it seems like my code is a little bloated and it runs kind of slow. I was wondering if there was any way to clean it up so that it will run faster. Any help or tips are appreciated!

Please Login or Register  to view this content.

Not entirely sure, but this line looks like you're looping through every column (+16K). It might be why your code takes a bit of time to run.

Please Login or Register  to view this content.