jwalkerack
Board Regular
- Joined
- Jun 19, 2013
- Messages
- 81
Hi there ,
i have a data set that is populated in a table , there are two set of data. one are fixed points such as time , location .
The other are variables specifically its a test number and test depth. For each sheet there are different amount of values . One test might have 30 rows of data the next might have 50.
What i want to be able to do is fill down my fixed data so it corresponds to the amount of test present.
So i have my data set below. I only have 1 entry for the first 4 columns , i would like this to be filled down to correspond to the 27 row. i have tried doing a copy and paste recorder . But my problem is that this will only copy to the values in the first test. In because the amount of rows will always change . i was wondering if there is a way of doing this . Thanks a lot Jack
<colgroup><col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:7314;width:150pt" width="200"> <col style="mso-width-source:userset;mso-width-alt:4937;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> </colgroup><tbody>
[TD="class: xl65, width: 137"]location [/TD]
[TD="class: xl65, width: 115"]Test Date[/TD]
[TD="class: xl65, width: 83"]Test Type[/TD]
[TD="class: xl65, width: 200"]Action number [/TD]
[TD="class: xl65, width: 135"]Report Test Number[/TD]
[TD="class: xl65, width: 112"]Depth [/TD]
[TD="class: xl63"]1_234_1234[/TD]
[TD="class: xl64"]30/04/1990[/TD]
[TD="class: xl63"]longhand [/TD]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]15115[/TD]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]15110[/TD]
[TD="class: xl63"]3[/TD]
[TD="class: xl63"]15111[/TD]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]15164.9[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]15246.9[/TD]
[TD="class: xl63"]6[/TD]
[TD="class: xl63"]15302[/TD]
[TD="class: xl63"]7[/TD]
[TD="class: xl63"]15303[/TD]
[TD="class: xl63"]8[/TD]
[TD="class: xl63"]15359.9[/TD]
[TD="class: xl63"]9[/TD]
[TD="class: xl63"]15356.9[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]15405.9[/TD]
[TD="class: xl63"]11[/TD]
[TD="class: xl63"]15417.9[/TD]
[TD="class: xl63"]12[/TD]
[TD="class: xl63"]15445[/TD]
[TD="class: xl63"]13[/TD]
[TD="class: xl63"]15489[/TD]
[TD="class: xl63"]14[/TD]
[TD="class: xl63"]15493[/TD]
[TD="class: xl63"]15[/TD]
[TD="class: xl63"]15491[/TD]
[TD="class: xl63"]16[/TD]
[TD="class: xl63"]15555[/TD]
[TD="class: xl63"]17[/TD]
[TD="class: xl63"]15553[/TD]
[TD="class: xl63"]18[/TD]
[TD="class: xl63"]15682[/TD]
[TD="class: xl63"]19[/TD]
[TD="class: xl63"]15702[/TD]
[TD="class: xl63"]20[/TD]
[TD="class: xl63"]15700.9[/TD]
[TD="class: xl63"]21[/TD]
[TD="class: xl63"]15766[/TD]
[TD="class: xl63"]22[/TD]
[TD="class: xl63"]15828[/TD]
[TD="class: xl63"]23[/TD]
[TD="class: xl63"]15885.8[/TD]
[TD="class: xl63"]24[/TD]
[TD="class: xl63"]15904[/TD]
[TD="class: xl63"]25[/TD]
[TD="class: xl63"]15888[/TD]
[TD="class: xl63"]26[/TD]
[TD="class: xl63"]15685[/TD]
[TD="class: xl63"]27[/TD]
[TD="class: xl63"]15766[/TD]
</tbody>
i have a data set that is populated in a table , there are two set of data. one are fixed points such as time , location .
The other are variables specifically its a test number and test depth. For each sheet there are different amount of values . One test might have 30 rows of data the next might have 50.
What i want to be able to do is fill down my fixed data so it corresponds to the amount of test present.
So i have my data set below. I only have 1 entry for the first 4 columns , i would like this to be filled down to correspond to the 27 row. i have tried doing a copy and paste recorder . But my problem is that this will only copy to the values in the first test. In because the amount of rows will always change . i was wondering if there is a way of doing this . Thanks a lot Jack
<colgroup><col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:7314;width:150pt" width="200"> <col style="mso-width-source:userset;mso-width-alt:4937;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> </colgroup><tbody>
[TD="class: xl65, width: 137"]location [/TD]
[TD="class: xl65, width: 115"]Test Date[/TD]
[TD="class: xl65, width: 83"]Test Type[/TD]
[TD="class: xl65, width: 200"]Action number [/TD]
[TD="class: xl65, width: 135"]Report Test Number[/TD]
[TD="class: xl65, width: 112"]Depth [/TD]
[TD="class: xl63"]1_234_1234[/TD]
[TD="class: xl64"]30/04/1990[/TD]
[TD="class: xl63"]longhand [/TD]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]1[/TD]
[TD="class: xl63"]15115[/TD]
[TD="class: xl63"]2[/TD]
[TD="class: xl63"]15110[/TD]
[TD="class: xl63"]3[/TD]
[TD="class: xl63"]15111[/TD]
[TD="class: xl63"]4[/TD]
[TD="class: xl63"]15164.9[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl63"]15246.9[/TD]
[TD="class: xl63"]6[/TD]
[TD="class: xl63"]15302[/TD]
[TD="class: xl63"]7[/TD]
[TD="class: xl63"]15303[/TD]
[TD="class: xl63"]8[/TD]
[TD="class: xl63"]15359.9[/TD]
[TD="class: xl63"]9[/TD]
[TD="class: xl63"]15356.9[/TD]
[TD="class: xl63"]10[/TD]
[TD="class: xl63"]15405.9[/TD]
[TD="class: xl63"]11[/TD]
[TD="class: xl63"]15417.9[/TD]
[TD="class: xl63"]12[/TD]
[TD="class: xl63"]15445[/TD]
[TD="class: xl63"]13[/TD]
[TD="class: xl63"]15489[/TD]
[TD="class: xl63"]14[/TD]
[TD="class: xl63"]15493[/TD]
[TD="class: xl63"]15[/TD]
[TD="class: xl63"]15491[/TD]
[TD="class: xl63"]16[/TD]
[TD="class: xl63"]15555[/TD]
[TD="class: xl63"]17[/TD]
[TD="class: xl63"]15553[/TD]
[TD="class: xl63"]18[/TD]
[TD="class: xl63"]15682[/TD]
[TD="class: xl63"]19[/TD]
[TD="class: xl63"]15702[/TD]
[TD="class: xl63"]20[/TD]
[TD="class: xl63"]15700.9[/TD]
[TD="class: xl63"]21[/TD]
[TD="class: xl63"]15766[/TD]
[TD="class: xl63"]22[/TD]
[TD="class: xl63"]15828[/TD]
[TD="class: xl63"]23[/TD]
[TD="class: xl63"]15885.8[/TD]
[TD="class: xl63"]24[/TD]
[TD="class: xl63"]15904[/TD]
[TD="class: xl63"]25[/TD]
[TD="class: xl63"]15888[/TD]
[TD="class: xl63"]26[/TD]
[TD="class: xl63"]15685[/TD]
[TD="class: xl63"]27[/TD]
[TD="class: xl63"]15766[/TD]
</tbody>