Background: I am trying to have the following code copy a set of formula's from a specific row. I have a database with headings starting in row 5, Column A (A5 to start everything). The first data line is in A6. Formulas are in Column A and Columns J:S.

What I am trying to do: There are times the person entering data will need to manually enter all of the data, and others that the information can be pulled via formula's using vlookups. I was going to make two buttons, one with the ability to copy down formulas and one that requests all of the information to be manually entered. I was wonder if there was a way to make to coding copy paste the formula from A6 to the new line when pressing the first button. Here is the copy paste code that currently works, as long as the formula's are in the row above.


Please Login or Register  to view this content.
any thoughts on how to set a formula cell anchor?