my question is similar to saban's post, "Find value in column." and djblois' "Find the last item and select it"(but I couldn't get any codes to work properly from djblois' post)
I have a spreadsheet detailing forecasted sales, and 2 of the details provided include quarter and year. I need to write a macro that will create pivot tables for every year. to do that, i need to be able to distinguish between quarters (Q1, Q2, Q3, Q4) of every year (so I don't wan't Q1 of 2006 and 2007 together). how would i do that? so far all i have is to sort the entries by year first then by quarter, but i have no idea how to return the range for every different quarter. could anybody help?
Reply With Quote