Forum Discussion
Jonathan Lollis
Jun 07, 2018Copper Contributor
End of Day Tasks
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#: |
No RepliesBe the first to reply