handysmurf
Board Regular
- Joined
- Jan 17, 2015
- Messages
- 89
- Office Version
- 365
- Platform
- Windows
I need to make a log for keeping track of documents. The finished Product would look like this.
I can get a list of the directory by using dir > list.txt, then parse the data in notebook, then import into excel which results in a list that looks like this.
If there is a shortcut in that process please let me know....
But as you can see from the example ... I need each file to be in column A which is merged over 8 rows ... while the details are not merged. In other words insert 7 spaces after each file name. Then merge each of columns A:D separately. This would take forever manually as there are almost 500 files. If i just cut and paste the file names and other information it unmerges.
Thanks in advance for any shortcuts to this process....
I can get a list of the directory by using dir > list.txt, then parse the data in notebook, then import into excel which results in a list that looks like this.
If there is a shortcut in that process please let me know....
But as you can see from the example ... I need each file to be in column A which is merged over 8 rows ... while the details are not merged. In other words insert 7 spaces after each file name. Then merge each of columns A:D separately. This would take forever manually as there are almost 500 files. If i just cut and paste the file names and other information it unmerges.
Thanks in advance for any shortcuts to this process....