1. I need VBA macro which would get values from two folders and multiple named files (*.xlsx and *.xls) with different named multiple worksheets in them.
2. Data in folders consist with monthly reports which have to be compared to each other and some data extracted to main file. One folder stores data from last month and other – files from current month.
3. There will be up to total 5000 tables and each folder and stored in multiple files. Files consist with other random and not relevant information.
4. Each table store data for unique device, which can be identified by number and special number placed in table column No 2.
5. The macro has to get/select values from all files and worksheets placed in 1st folder, table Col No 6. “End of the month” for Meters placed in table Col No 4: “Total Units”, “Units Won”, “Hand pay” and “Played games”. Those values have to be compared with values placed in all files and worksheets placed in 2nd folder, table Col No 5. “Beginning of the month” for Meters placed in table Col No 4: “Total Units”, “Units Won”, “Hand pay” and “Played games”. If values from table Col No 6 “End of the month” do not match data in table Col No 5 “Beginning of the month” macro should print list of “Device No / special No" on separate file worksheet.
6. Also, the macro should additionally calculate RTP from 2nd folder (RTP is calculated when table Col No 6 value “Units Won” is divided by “Total Units” value) and print “Device No / special No” together with RTP results.
7. It should be noted that tables can be placed on different cells on worksheets and same table can have additional Meters (e.g. “Coin In” and “Coin Out”) which is not necessary” for a task.
8. FileNo1.xlsx represent Folder No 1 and FileNo2.xlsx represent Folder No 2
If you have any questions please let me know.
I really appreciate your help!
Bookmarks