I have a self created excel sheet with invoice amounts that I email weekly, based on a pay period date range. I input the cell data, post the date range, and the spreadsheet autocalculates the total invoice amount between the dates specified.
I am attempting to automate this process, where either a macro or VBA code is attached to a button that will save the invoice as a PDF, automatically setting the print tile range in excel to only the array data contained within the pay period date range provided. I am at a loss here, and I know it will require formulas within formulas to achieve the desired effect.
So, to recap, I need to create a button that will look at the pay period dates, save an invoice as a PDF by automatically opening page layout > print tiles > and edit the fields based on the date range I input within the pay period fields in excel. The print tiles "print area" is based on row numbers and columns. So I need it to find the date range, extract the row numbers and columns, and paste that info into the “print area” field in the print tiles section. Then save it as a PDF by clicking the button.
The PDF name also must be formatted as the pay period dates in this exact format: “MM/DD/YY - MM/DD/YY”. Also needs to save it as a PDF in a specific folder in the cloud.
I assume this must be VBA. Can’t imagine an excel formula or macro can do all that.
I need help here. I dont have enough experience in VBA or formula creation to achieve the desired effect im looking for here.
I am attempting to automate this process, where either a macro or VBA code is attached to a button that will save the invoice as a PDF, automatically setting the print tile range in excel to only the array data contained within the pay period date range provided. I am at a loss here, and I know it will require formulas within formulas to achieve the desired effect.
So, to recap, I need to create a button that will look at the pay period dates, save an invoice as a PDF by automatically opening page layout > print tiles > and edit the fields based on the date range I input within the pay period fields in excel. The print tiles "print area" is based on row numbers and columns. So I need it to find the date range, extract the row numbers and columns, and paste that info into the “print area” field in the print tiles section. Then save it as a PDF by clicking the button.
The PDF name also must be formatted as the pay period dates in this exact format: “MM/DD/YY - MM/DD/YY”. Also needs to save it as a PDF in a specific folder in the cloud.
I assume this must be VBA. Can’t imagine an excel formula or macro can do all that.
I need help here. I dont have enough experience in VBA or formula creation to achieve the desired effect im looking for here.
