Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare xls & mpp files against a master file register then flag missing.
Hi,
Excel 2003 On either a weekly or fortnightly cycle, I have to check against a master register of file names, files that may or may not exist in two separate locations on a shared drive, and flag up files that should be there. One folder contains xls files, the second folder contains mpp files. I need to bring the names of these files into a spreadsheet, then compare against the master file registry. Can anyone point me to a macro which could show me the right steps to take? Regards Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to compare totals and flag those less than or more than | Excel Discussion (Misc queries) | |||
collate rows from several files into one new master file | Excel Discussion (Misc queries) | |||
I have 1 master excel file & want to rec. data from 7 other files | Excel Worksheet Functions | |||
VBA Challenge - Flag Missing Info | Excel Programming | |||
VBA Challenge - Flag Missing Info | Excel Programming |