Hey there everyone.
We have a directory that exists on multiple computers. We have a script that will get the file list for these directories. It puts them in the workbook in new sheets per computer.
We are trying to create something that will create a report showing what files aren't on the "Main" computer. Which ones are the newest dates among all the computers.
Data format
WorkBook.Sheet.MAIN
<tbody>
</tbody>
WorkBook.Sheet.PC1
<tbody>
</tbody>
WorkBook.Sheet.PC2
<tbody>
</tbody>
Any guidance would be appreciated
We have a directory that exists on multiple computers. We have a script that will get the file list for these directories. It puts them in the workbook in new sheets per computer.
We are trying to create something that will create a report showing what files aren't on the "Main" computer. Which ones are the newest dates among all the computers.
Data format
WorkBook.Sheet.MAIN
Full name | File Name | Date |
\directory\user\folder\file1 | file1 | MM/DD/YYYY |
\directory\user\folder\file2 | file2 | MM/DD/YYYY |
\directory\user\folder\file3 | file3 | MM/DD/YYYY |
\directory\user\folder\file4 | file4 | MM/DD/YYYY |
<tbody>
</tbody>
WorkBook.Sheet.PC1
Full name | File Name | Date |
\directory\user\folder\file1 | file1 | MM/DD/YYYY |
\directory\user\folder\file2 | file2 | MM/DD/YYYY |
\directory\user\folder\file3 | file3 | MM/DD/YYYY |
\directory\user\folder\file4 | file4 | MM/DD/YYYY |
<tbody>
</tbody>
WorkBook.Sheet.PC2
Full name | File Name | Date |
\directory\user\folder\file1 | file1 | MM/DD/YYYY |
\directory\user\folder\file2 | file2 | MM/DD/YYYY |
\directory\user\folder\file5 | file5 | MM/DD/YYYY |
\directory\user\folder\file6 | file6 | MM/DD/YYYY |
<tbody>
</tbody>
Any guidance would be appreciated