There are 100 Excel files, you need to take data from each and enter it into one pivot table, files are added over time, how to do this so that information from new files is dynamically added to the pivot file, the problem arises when checking the number of files. How can you check the number of Excel files in a folder?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.