Hi,

I have 2 sheets to work on. Sheet1 is a database of formula and Sheet2 is where I want the formula to be pasted to.

Sheet1 has the formula and the cell where it should go in Sheet2

I cant figure out how to execute the copy pasting one cell at a time from one sheet to another. Also, the number of formula to copy depends on what's on Sheet2

See attached.CopyPasting one at a time.xlsx

Thanks everyone!