I am trying to a build an excel based macro that would enable me to generate multiple reports in one go. One sheet of the excel workbook would have all the data, and based on some pre-existing conditions, certain logics should be run and accordingly some tabs and some text will get picked up to be presented in the report. The report is converted into a PDF format and saved in a specific folder. Further, the reports should be linked to MS Outlook or gmail for mass distribution.
Most of the tool has already been developed, but need somebody to fine tune it and make it better.
Please bid only if you're comfortable with statistics and logical programming as this would required you to understand complex loops.
Would need frequent screen sharing to see progress, so you must have access to a good internet connection and should be comfortable working with the Eastern time zone.