Date Selector

E

Enyaw

I have data validation on a cell in a worksheet. It has a list with
yesterday, today, this month, last month, this quarter, last quarter, this
year, last year. How would i program that when one of these items is
selected the start date and end date are entered into two cells onto the
worksheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

End of Quarter Based on Fiscal Year 2
Excel Vba to change displayed year automatically. 14
How to read the current grouping of a pivotfield in a pivottable 7
VBA for Month and Quarters Output 10
Combine 2 columns in a dynamic range into one 7
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Add to a cell if a row has a date and a column has a department 2
Dates and Strings: Last day of the quarter - string "Mar 04" to #5/1/2004# ????? 1

Top