Please advise if it is possible that a VBA code automatically update the data if there is change made?
I am using the below code to add 38 sheets of data in the same workbook, to 1 sheet (also in the same work book)
But if I make changes to data on a sheet, the combined sheet, does not update automatically, I have to run the code again
So I need to know if there is a way that it updates automatically?
Please Login or Register to view this content.