Macro for populating spreadsheet with formulas
 

Hello All

What I am trying to do is create a macro that populates a spreadsheet with 10+ columns of formulas for a number of rows that will be determined in the macro. The formulas will reference data from another worksheet that will also contain the data for the number of rows.


The first spreadsheet contains data about a continues length of pipe (a drill string)

OD…weight/foot…Length
4……………5……………3
5…………..50……………1
8…………..15……………2


The second spreadsheet will do a set of incremental calculations (every 1 feet) along the length of that pipe that are either cumulative (depth and total weight) or increment specific (cross sectional area).

Depth…Total Weight…Cross Sectional Area
1…………………5…………………..12.6
2…………………10…………………12.6
3…………………15…………………12.6
4…………………65…………………19.6
5…………………80…………………50.3
6…………………95…………………50.3

These aren’t the exact calculations I am trying to do but if I can get these sorted then I will be good-to-go. Even if you only have partial solutions or suggestions anything would help.

I know this is a lot so I appreciate any help. If you have any questions please ask.

Thanks
-Johannes