How do I automatically copy formulas to new rows as new rows of raw data are added?

Initial clarification: I don't want to have to go through to normal dragging process for copying fomulas to new cells. That's not what I mean by "automatically." On to my question...

In Sheet 1 I have my raw data. Sheet 2 contains my formulas that analyze this data. The way I am analyzing the data works out so that each row on Sheet 2 is analyzing its corresponding row on Sheet 1. For example, Row 2 of Sheet 2 produces outputs based solely on the data in Row 2 of Sheet 1. Row 3 of Sheet 2 uses only info in Row 3 of Sheet 1, etc.

As an initial setup, let's say I have 3 rows of raw data in Sheet 1. Therefore, I have 3 rows in Sheet 2. Is there a way that I can program my formulas in Sheet 2 so that they'll automatically copy themselves to the new rows as I add new rows of raw data in Sheet 1? Maybe there is some way that a dynamic range can help solve my problem?

Thanks!

Cross-post link

maxedison,

Please read forum rules and message to cross posters.
If you post to another forum you must add the link

VBA Noob