rjackson104
New Member
- Joined
- Jan 31, 2019
- Messages
- 1
Process to Automate after the first invoice
1. Column E - currently equals the value in O7, updates to P7 on next invoice then Q7 and so on
2. Copy value of column I to column O for invoice 1 then one column to the right after each subsequent update
3. Returnall values in column G to 0% for manual updating
4. Save file as "filename" inv# noted in E9 and column 07 line 8 for invoice 1, it will change with each invoice (rbj sample excell invoice [Mar 2025]-01)
5. Print invoice file as a PDF - landscape and as 1 page (rbj sample excell invoice [Mar 2025]-01)
1. Column E - currently equals the value in O7, updates to P7 on next invoice then Q7 and so on
2. Copy value of column I to column O for invoice 1 then one column to the right after each subsequent update
3. Returnall values in column G to 0% for manual updating
4. Save file as "filename" inv# noted in E9 and column 07 line 8 for invoice 1, it will change with each invoice (rbj sample excell invoice [Mar 2025]-01)
5. Print invoice file as a PDF - landscape and as 1 page (rbj sample excell invoice [Mar 2025]-01)
