Creating a Template that posts data to another Sheet

You certainly need macros to do this.
Would it be possible to attach your workbook to your thread so we can work on your actual data structure?
It would assure you a working system based on your needs.
Regards

See attached workbook.
I added a button. You just have to click on it to transfer data to Data sheet.
It actually copies the whole 2 columns C and D and clears the data in C3, C5 and C15 where I think you'll be entering new data. You may add or adjust your formulas in those columns as you need to.
I only copy values of those columns. Not the formulas. If you need the formula you can change the pastespecial line of code.
Hopes this helps

First, I have to ask you to modify you last post so that your code is enclosed in CODE tags as per rule #3. Here is how to do it:

Rule #3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

[ code ]
your code here ...
and here ...
and here
[ /code ] 'Don't forget to erase the spaces I added after and before the brackets to show you how it looks

Now about your problem, I'm not sure I follow you. You are adding formulas to column P and Q. Is this done on the Data sheet? In your first workbook, there was only a description in column P. If you added something in column Q, you have to change some of the code to make sure the 2 columns from Template are copied to the proper place.

Actually, formulas in columns P and Q would not be changed by the macro and they should not need any modification. Unless there is something I don't understand.
Could you attached your modified workbook so I can take a look and please put some more explanations of what you want to do.
Regards