Using a filter while recording a macro problem

I am currently trying to record a macro in the attached sample spread sheet. The idea:

Use a VLOOKUP in the location spread sheet to find only items that are listed on sheets "A, B, C....".

Use the filter to get rid of all N/A that come up so a quick copy and paste can be done from the location spread sheet onto the letter spread sheet.

Continue until letter J is complete.

The problem i am running into is that after I record the macro the spread sheet will only go thru the "A" spread sheet then the macro will freeze and I have to force close excel. The macro in the attached spread sheet can be run by ctrl + a. I'm a litte in over my head on this and have been trying to get this to work for 3 days with no such luck.

I hope someone here can help, any other suggestions will also be willingly apprecaited.

Thank you,
Andrea

Hi

Slightly different approach, but see if it gives you some ideas.

849386.xlsm

rylo

Hi,

Why are you hiding the N/A errors instead of getting rid of them?

I think the problem might be that you are using full column ranges A:B instead of cell ones A2:B300 or dynamic Ranges.