I have searched for this but I have no idea what kind of fuction this is so I can't find any information on how to do this. In sheet 1 I have data that tracks information by Month. What I want is for sheet 2 to automatically update information for the correct month and month to date when you select that month in cell A1. I hope this makes some kind of sense? Sheet 2 is a reporting tab which includes graphs and I want them to update accordingly. I'm sure there must be formulas that can do this?!
Thanks