Hello and welcome to JustAnswer! My name is XXXXX XXXXX I would be glad to assist you with your issue today. Please note that I am in eastern time (UTC -5:00) and am generally online between the hours of 10 AM and 4 PM and some evenings between 7 PM and 11 PM.
I would be glad to take a look at these workbooks for you if you wish to send them over (if that is ok).
after looking at it again, I see that it is around line 125 on the main workbook that it stops sending the data. Not 85
Sorry for the delay. I will review this now.
I have to head in to work. Leaving chat. I'll check back later today. Thank you for your efforts.
What book/sheet am I looking at (i guess for the main sheet)?
The main sheet contains the data. Also it summarizes the categories of the drop down menus in the later columns (AM through BJ) and arranges it into ascending order without spaces. The sub books retrieve the corresponding file numbers from those columns and then is supposed to pull the data information from the main book to the sub books.
I worked on it some more. And it is working now. Here is what I did:
sorted in ascending order "again" column "F" a reference error appeared at the top. it was the count function I then deleted it and opened up a sub workbook. They all updated correctly.
Thank you for your efforts