Excel VBA Issue - Intricate Coding
$8-15 USD / time
This file has a lot of VBA and SQL queries coded in to help with automation/reporting. The way the file is designed is below:
• “Run Report” (triggered from VBS file) macro is run
• Queries Refresh and change dates to look for last fiscal period/week
• Emails go out based on alignment from helper tab
Issues
• Ranges seem out of sync
• Most of the respective team isn’t getting their email (b2-b12 on helper tab) because of other bugs (some are receiving). Tabs "Top 5/Bottom 5", "top 10 DOH", Bottom 10 DOH arent getting emailed to them with their respective alignment (parent/child). All tabs highlighted in some type of green are reports that get sent
Workbook password is “fullhouse”. Please let me know if you have any questions
If needed I can provide access to VM - where the file resides. Again, the emails go to some but not all. There are a number of issues here and a very intricate/complicated VBA
Projekt ID: #28215479