This is going to be hard to explain so I hope I can explain it good enough.
We have a workbook with many sheets that are dependent on each other. A problem is occurring when I import data from a file and it gets mapped to the appropriate row on one of the sheets.
We start on (Sheet27) and run the update it goes and looks at the import sheet data grabs the data and then puts that onto (sheet7)
I think the problem is The range the data gets put into is hidden until the next batch is imported then it unhides the next row ready for import.
I want to be able to run the import from Sheet27 and not have to go and view Sheet7 to trigger its code on its change event.
How can I get it to run the code and update the other sheet and have that sheet still update its coding properly in the background without having to look at it every time. I tell it to activate the sheet in the code thinking it recognizes the change event and then runs it code in the background but it is not doing that.
Hope you can understand it.
This is the change event on the sheet
Bookmarks