Corin Young
New Member
- Joined
- Oct 10, 2016
- Messages
- 5
Howdy!
I need help trying to create two items.
I will illustrate the purpose of my worksheet. I am creating a database that will allow the user to identify which customers need to be contacted on that particular day. For example – If today is 10/12/16, I have utilizing conditional formatting to highlight the cells containing today’s date.
1. How do I create and search box, toggle, scrollbar, ?, etc. to be able to take me to ALL cells containing the conditional formatting of today’s date? Almost like a FIND/FIND NEXT command but creating user friendly tools. The worksheet will be large and I don’t want to count on scrolling through the whole spreadsheet daily.
2. In the same breath, how do I create a lookup field to find a particular work order number located within that sheet? Again, almost a find feature without using keyboard shortcuts.
I imagine a search box and toggle (for the cells housing today’s date) located at the top of the worksheet. Any cool ideas out there?
Your help is so much appreciated!
I need help trying to create two items.
I will illustrate the purpose of my worksheet. I am creating a database that will allow the user to identify which customers need to be contacted on that particular day. For example – If today is 10/12/16, I have utilizing conditional formatting to highlight the cells containing today’s date.
1. How do I create and search box, toggle, scrollbar, ?, etc. to be able to take me to ALL cells containing the conditional formatting of today’s date? Almost like a FIND/FIND NEXT command but creating user friendly tools. The worksheet will be large and I don’t want to count on scrolling through the whole spreadsheet daily.
2. In the same breath, how do I create a lookup field to find a particular work order number located within that sheet? Again, almost a find feature without using keyboard shortcuts.
I imagine a search box and toggle (for the cells housing today’s date) located at the top of the worksheet. Any cool ideas out there?
Your help is so much appreciated!
