Hi All!
I'm building a report to skip over Covid so I can compare current months to corresponding pre-covid months... In some instances I'm looking for the month that's two years ago {2} and sometimes it's three {3}...
Is there a way to toggle back and forth using a numeric input somehow so I'm typing 3 into a cell instead of navigating to the formula bar, highlighting the 2 and then typing 3?
Alternately, there seems to be a bit of a pull down list on the .ColSpec line, but I don't know how to populate it... if it had {2} and {3} that would be great, but it has some other random selections instead...
Thanks for any thoughts!