How to define a cell name and reference it in a differen sheet

You MAY be able to use a Dynamic Name for the cell.

See if this link helps:
http://www.contextures.com/xlnames01.html

If not upload a small sample file (with no private data) to illustrate what you're doing.

Originally Posted by Cutter

You MAY be able to use a Dynamic Name for the cell.

See if this link helps:
http://www.contextures.com/xlnames01.html

If not upload a small sample file (with no private data) to illustrate what you're doing.

Cutter,
I think I get the idea, however, the data I am trying to pull into another sheet is from a column sum of minutes testing is run. The longer testing goes the more minutes will be recorded thus changing the cell where the total minutes accumulated is varies each time I pull the data via a macro.

Attached is a copy of the file, it has no sensitive data in it