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