I'm trying to automate some detail on my worksheet and I need to be able to enter the first quarter for a specific year and then have it list the quarters from that entry all the way through the last quarter of 2011.
Cell J13 = Q1-08 so I would want cell K13 to show Q2-08, etc. all the way through Q4-11.
I want to just enter the quarter/year in cell J13 and have it calculate the rest of the quarters automatically. This way I only have to enter the starting quarter and have the formulas do the rest.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…