HI,
Basically I want to divide a number of cells by a number in another cell. So
say, A1 through A10 by C3. However, I do not want to make the change
permanent, and I want to be able to see what the values would be if C3
changes. So apart from manually going thru and adding the = and /C3 is there
a way to map that = xC3 to the original cells. (I know its a circular
reference of sorts, but can i write a macro to perform that task for me.. or
is there some other way?)
Thanks
Bookmarks