If I'm understanding your question correctly, you need only reference the
formula in the cell in which you want the data to appear. You may need to
make the formula cell references absolute. This can be done with the F4 key.
If this is helpful, please click on the Yes below.
Thank you