- Feb 5, 2006
- Office Version
Good day. I am running Excel out of Office365 (updated) on Windows 10 Home. I have a workbook that creates a worksheet by extracting data from my Music folder. The Music folder now contains 4500 files and is constantly being updated, so the number of files in that folder varies every day. The Macro in the worksheet copies eight elements from the File Properties of each file in the Music folder. All of that works. After creating each worksheet, I would like to be able to sort the data in the new worksheet using one or two of the columns in the new worksheet. Since the count of Rows in the worksheet changes, I need to have the Macro determine the last Row of data in the worksheet. Any help is appreciated.