Copy & Pasting Formula to Cells in Another Sheet

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!

Maybe this:

Please Login or Register  to view this content.

Hi,

It's close. It's doing what I wanted to do but

It seems to be deleting other data. I have attached the file that I am working on. Book1.xlsx

Sheet1's name may change depending on user preferences.

It is important that data in Sheet1(budget) does not change except the addition of the formula to specific cells.

Originally Posted by smartbuyer

It seems to be deleting other data.

In the code there isn't anything that would change/delete any other data other than cells of the addresses you have.

Here is the amended code for book1

Please Login or Register  to view this content.

Originally Posted by millz

In the code there isn't anything that would change/delete any other data other than cells of the addresses you have.

Here is the amended code for book1

Thanks Millz! I figured that one out, Now I'm looking to add a code that will drag the formula (dynamic cell range) offsetting it 11 places to the right. Help?

If I get what you mean.

Please Login or Register  to view this content.

How do I code this:

If Sheets("Formula List") Range("H) is in Cell "C" then

Please Login or Register  to view this content.

If Sheets("Formula List") Range("H) is in Cell "D" then

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please read forum rules about cross posting

You. are. awesome!!

Originally Posted by millz

Please Login or Register  to view this content.