Automatically change reference cell each month
 

I have set up an extensive workbook with multiple tabs for our monthly
dashboard. My goal is to automate as much of it as possible to take human
error out of the equation. I have the first tab set up as the dashboard
display and used conditional formating for the color representation on the
data points. Each data point refers to the data entry page for the month. It
is set up to enter the raw data on the entry page and it does the
calculations automatically. Currently I have to go into the display tab and
change the cell reference to the next colum on the data entry page. I would
like to know if there is a way to make the references automatically cycle to
the next column each month when I input the data?

Automatically change reference cell each month
 

See other post

Biff

"Balzyone" wrote in message
...
I have set up an extensive workbook with multiple tabs for our monthly
dashboard. My goal is to automate as much of it as possible to take human
error out of the equation. I have the first tab set up as the dashboard
display and used conditional formating for the color representation on the
data points. Each data point refers to the data entry page for the month.
It
is set up to enter the raw data on the entry page and it does the
calculations automatically. Currently I have to go into the display tab
and
change the cell reference to the next colum on the data entry page. I
would
like to know if there is a way to make the references automatically cycle
to
the next column each month when I input the data?