Hello,

I am a newbie to VBA and i've been trying to figure out how to update a graph based on the current month/latest available data and then looking back six months in total. No luck! I looked at using defined names with functions, such as COUNTA, but as you'll see from the attached, there will be ref errors in there as the spreadsheet will draw new data every month from a different spreadsheet.

Please can anyone show me how I would do this using VBA or formulas?

Many thanks,

Aminul