Forum Discussion

Jonathan Lollis's avatar
Jonathan Lollis
Copper Contributor
Jun 07, 2018

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

Resources