We have A,B,C....up to z Stores they will do the Audits on regular Basis.
We need to send emails for variances, is there a way we can send in one click.
All Variances will be in one sheet with store Name.
We have A,B,C....up to z Stores they will do the Audits on regular Basis.
We need to send emails for variances, is there a way we can send in one click.
All Variances will be in one sheet with store Name.
You will need to do two things:
Loop through a Range of Cells in Excel VBA/Macros
Both links have sample code that should get your started in your project.