Please read this carefully. The task is to locate Excel files having a specific filename (ie. starting with I 19, I 20 etc.) in a specific folder (incl. all subfolders) on a company drive (around 50 to 200 files).
Then, a worksheet should be extracted (it has always the same name) and copied to a new Excel File in the original folder. During the process, the extracted worksheets should be renamed with the filename from the original file. It should be checked, whether there are any changes from the last import to reduce runtimes, (unchanged files should be ignored). The original files should not be altered.
Then, in the newly created Excel file, certain cells (around 20, always the same structure in each worksheet) should be extracted to a new worksheet (eg cells E:8, G:8 and F:12 etc.) and written in one line in this new data worksheet (eg. “results”). While processing, the expected data structure per cell (text, date or number) should be checked, errors should be shown to the users (and the respective cells ignored).
We provide sample sheets of the original document and the target document with some test data (10 to 15 filled out excel files). In the target document, the cell references and the cell target format can be seen. Output is a smoothly running VBA macro generating the “results” worksheet in a flat data structure. The macro should be compatible to Excel 2013 to 2016ff and compatible to German syntax and formats (eg "1.000.000,00") and “20.11.2019”. Comments can be in English, we provide the translations for the error messages. Max. Budget is 80 USD.
Please add “understood” to your bid to show you have actually read this brief.