Hi,,
I'm not sure if this request should be here under the VB forum,,I'm not even sure if its possible to do,,
What I want to be able to do is,,press the Q key and either Q1, Q2, Q3 or Q4 based on certain parameters appear in that cell,,
Hopefully I can explain this clearer,,
In column A of my spreadsheet heading 'Quarter', I want to be able to specify which quarter of the year a request was made,,so when I press Q
> if the date is within 01/01/14 and 31/01/14 'Q1' will appear
> if the date is within 01/04/14 and 30/06/14 'Q2' will appear etc,,I'm sure you can workout Q3 and Q4,,
Ive named a cell A1 'TODAY' for reference it has the formula =TODAY() in it and shows whatever the date,,
I have looked at the DATE commands available but I don't think any could do what I need, that's why I was thinking I needed a piece of VB code,,
Any help would be much appreciated,,
Regards,
KJMOSP
Bookmarks