Geology Logging and Sampling using Excel

[Geomercenary]

Hello Excellers,

I am actually a Geologist and just familiar with the basic functioning of Excel. My fieldwork involves logging of drill cores at regular depth intervals followed by further division of those depth intervals to less than 1 meter or so to be sent to the lab for chemical analyses of the rock type collected. I am demonstrating the exact nature of my problem below, please keep in mind that I might not be able to use technical mathematical/statistical language.

1.Following is the Lithological logging book entry (Length unit in meters)

From To Run Core Recovery Core Recovery% Lithology
0 3.05 3.05 2.64 %(2.64/3.05) Limestone med grained etc.
3.05 6.10 3.05 1.8 %(1.8/3) Limestone with shale
6.10 8.20 2.10 0.75 %(0.75/2.10) Shale

..... and so on
In the above table I would require the From, To, Core recovery and Lithology data to enter and the rest could be automatically calculated. This sheet is manageable but the problem is the next step

2. The Sampling book entry

Sample No. From To Run Sample Length
1. 0 1 1 (2.64/3)
2. 1 2 1 (2.64/3)
3. 2 3.05 1.05 (2.64/3)
4. 3.05 4.05 1 (1.8/3)
5. 4.05 5.05 1 (1.8/3)
6. 5.05 6.10 1.05 (1.8/3)
......
and so on
So here we divide each row showing the run in the Lithology book to sub-intervals of 1m each(or around that) and mostly our machines have a unit drill length of approx. 3m each hence we divide each entry to three parts and subsequently divide the core recovered from each run to 3 equal parts as well. I would want this sheet to get automatically populated as soon as I start entering data into Lithology book.

Kindly help me with the same as soon as possible regarding a VBA script or a formula for these two separate sheets.

If you need any more details kindly respond.

Thanks in advance.