yeah, i could do that, but i didn't want to have to run the macro every few
minutes(its data that comes out every few minutes); also it wouldn't be the
same cell that i'm copying/ pasting; it would be like a column of formulas,
and i would want to copy paste row by row every few minutes.
(i can do simple macros, but nothing too complicated--but i was hoping for a
formula or function that could help accomplish this)