I am wanting to create a link on worksheet B to each cell in worksheet A that does not give an error #REF when the worksheet A cell or row is deleted. I even attempted to use the INDIRECT function, but I couldn't copy that formula down without having to re-type the cell reference.
What...