I have two Macro buttons on my spreadsheet for work. I am needing to make a third that will select the next three blank cells in a row, merge them, add a bold border, and input the next days date in regular form without using a formula (so not =today()+1, just the result of =today()+1), and then to invoke the macro currently in place to clear out all input fields on my forms. This is used to store information regarding call transactions in a call center, So I can only give you a blank example of this below. I know this is a major thing for a single button, but it would shave minutes off me leaving once I clock out for the day.
| 1/12/2018 |
| | | |
| Caller / Customer: | | |
| Agent: | | |
| 1) Inquiry: | | |
| 2) Resources used: | | |
| 3) Steps taken: | | |
| 4) Additional Comments: | | |
| 5) Outcome: | | |
| 6) Language: (DR Only) | | |
| 7) Symptom Description: | | |
| 8) NCP Parts Needed: | | |
| Issue: | | |
| Action Taken: | | |
| Additional Notes: | | |
| Original DOP: | | |
| Original PO: | | |
| Original MSN: | | |
| Policy Type: | | |
| Empowerment Policy#: | | |
