I have built a sheet for a sales team and I would like to provide them a way when entering data about a sale, to instantly add a "sub-row, or set of sub-rows" so that they can provide data based on each location, that when closed, is the sum of the total account value?
Example of data input for a single location is below, however, if they want to input data that will "roll up' to that main Acme Company location, so that the total account value ($100 for the main location, $50 for location 2, $150 for location 3) is $300 can that be done?
<COLGROUP><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3157" width=89><COL style="WIDTH: 148pt; mso-width-source: userset; mso-width-alt: 7025" width=198><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3868" width=109><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4152" width=117><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3356" width=94><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3555" width=100><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3015" width=85><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3527" width=99><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3100" width=87><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2872" width=81><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3527" width=99><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2929" width=82><TBODY>
</TBODY>
Example of data input for a single location is below, however, if they want to input data that will "roll up' to that main Acme Company location, so that the total account value ($100 for the main location, $50 for location 2, $150 for location 3) is $300 can that be done?
| VOICE PRI | ||||||||||||||
| PRODUCT | MRC | PRODUCT | MRC | PRODUCT | MRC | PRODUCT | MRC | TOTAL | ||||||
<v:shapetype id=_x0000_t201 path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v ath o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"></vath><o:lock shapetype="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 1; POSITION: absolute; MARGIN-TOP: 0px; WIDTH: 66pt; HEIGHT: 12.6pt; MARGIN-LEFT: 0px; mso-wrap-style: tight" id=CheckBox1 type="#_x0000_t201" o:insetmode="auto" strokecolor="windowText [64]" stroked="f" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9 Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/ 8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj 39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA ACEA4juCZbIBAADxAwAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykU9tu1DAQ fUfiHyy/02xCtVqiZivY0gqpglWBD5g6k9iqb7LdkP49402arlYCIfpme2bOnDlnfHE5Gs0GDFE5 2/DybMUZWuFaZfuG//xx/W7DWUxgW9DOYsOfMPLL7ds3F1D3AbxUghGCjTU0XKbk66KIQqKBeOY8 Wop1LhhIdA190Qb4RchGF9VqtS4MKMu3L1BXkIA9BvUfUNqJB2x3YAeIBKlFffwyc9Ti9chQ2+Em +O9+HzJz8XXYB6bahpNyFgxJxIs5MKfRtTip6l8Axi6YnO+6jo3kAGdPDa/ON+dltZqQcExMUGjz fkOqcSYooVyXH6r13El++2OtkJ//Wk3EJgJ0OCLllcic7LBX4nTO6nnOnUTx8MmN5TLwkk31t2RI ZNbtJNgeP0aPIuXxJjWybBP0QZql8F4rf620zt3zeTYu/ItvpKASeOXEo0Gbpg0LqCHRakepfOQs 1GjukcwKX9qZdkwBk5C5YUeN74jmRHEJEMNjWnF2/rXGLdJD7UNMN+gMywciRxwO3wKG2zizeU45 7NJEgQBIZ3o4WfZDyvw58486vm9/AwAA//8DAFBLAwQUAAYACAAAACEAU1KJYdIAAACrAQAAKgAA AGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc6yQwUoEMQyG74LvUHK3 mdmDiGxnLyLsVdYHCG2mU5ympa3ivr3VvTiw4MVLIAn58vHvD59xVR9cakhiYNQDKBabXBBv4PX0 fPcAqjYSR2sSNnDmCofp9mb/wiu1flSXkKvqFKkGltbyI2K1C0eqOmWWvplTidR6Wzxmsm/kGXfD cI/lNwOmDVMdnYFydDtQp3Pun/9mp3kOlp+SfY8s7coLbN2LO5CK52ZA68vkUkfdXQGva4z/qRFi j2CjEdkFwp/5qLP4bw3cRDx9AQAA//8DAFBLAwQUAAYACAAAACEA6kqyABAGAACyGQAAGgAAAGNs aXBib2FyZC90aGVtZS90aGVtZTEueG1s7FlLbxs3EL4X6H9Y7L3RW4qMyIGth93GboJIcZEjtUvt MuI+QFJ2dCuSY4ECRdOilwK99VC0DZAAvaS/xm2KNgXyFzrkPkRKVB5GDkFhGTB2Z78ZDmdmvyG5 167fj6hzihknSdxza1eqroNjL/FJHPTcO5PRR1ddhwsU+4gmMe65S8zd67sffnAN7XiUpNMEMX8S 4gg7YCjmO6jnhkKkO5UK90CM+JUkxTE8myUsQgJuWVDxGTqDASJaqVer7UqESOzugkUhDQ0p/IsF lwKPsrE0g50YRTD6zdmMeFhh/XlNIviS9ylzThHtuWDTT84m+L5wHYq4gAc9t6p+bmX3WgXt5EpU bNHV9Ebql+vlCv68rsZkwbQctNlsNdt7pX0FoGITN+wM28N2aU8BkOfBTDNfdJut/e7+oJVjNVB2 abE96AwaNQOv2W9s+LzXkn8GXoEy+80N/GjUhygaeAXK8K0NfLPZqfebBl6BMnx7A9+p7g2aHQOv QCEl8XwDXW21G/1itiVkltBDK7zbao469dz4CgXVUFaXHGKWxGJbrUXoXsJGAJBAigSJHbFM8Qx5 UJN9RMmUEeeIBKGQw6AdjLTnmcjjGyI5osM9RlLRcz9JUexqkJfPfn757Ilz/uDp+YPfzh8+PH/w a2bI0DpEcaBrvfjxq3+//9z558kPLx59Y8dzHf/nL1/88fvXdiC8RKtJPv/28V9PHz//7su/f3pk ge8xNNXhExQmEbIAD/GU6cADwkMbbhIiouO2GhyK0AB+ukTUZnAfm5E6YUAWNuDB4p7h4ThkC0Es U7kRRgZwgBbxLRyHNqgcSovmZBEH9rHZQsfdRujUNnQfxUYah4sUSJLYTPZDbHh5i6JYoADHWDjy WTLH2OLxXUKMsB4TjyU8mQnnLnH2EbFGZEKmRtGslA5JBGlZ2hyETBuxOT5x9hNqm/UAn5pIKH5E Lc5PMDXCeIAWAkU2kxMUUT3gR0hYy3G8ZJ6OG3LBYHRME2foY85tE7vJYL5a0m8AT9jTfkyXkYlk gsxtNo9QkujIQTLvhyhKbdgxgVrUxv+Yz5OEIudWImzw48R8QeQ95AHFW9N9QrCR7q3v6B1gRt2T VV3IJwtmSeEBToyyHS/pDOFYIoG4DT6OSPxacs5GuKTlS1rWe+6NS1q+pOX/PS2fYOaj2Eb5756X V1QMLL1aUav1dbR1eT0jlI7FkuIjrlbYHPqOPwKh1FPbSFxut9IQLvM2YOAChpSOwxLxGRHhOEQp rM5rrjQS8Nx0wJ004bArVGKrbYmni+g48bNdZa0md5BZB+FIrOTVVimHHYHI0O3OaqdUmldNK1A7 2sIBqfs2TmiDmU40LE50CiFk4VVOqJm9Ey+6Fi+uSvNFqtQuHlJXhgJcK7MCCyMHllM9t9UEFVCC bRGi2Jd5yjp+kV2VzHeZ6W3BNCqgCscUeQWsMt2Vvm6dnpxdVmpvkGnDCa3cTCdUZNT+EvZMPs6r U0rfxI23zXV3lVLDPRmKPBaaG52rr/LiormWJLLGDTTWmYLGzlnPbTdaUDIeSnvuDHbncBmlUDtc LmgRDeBcyxMse+Evwiwp42KAeJgFXJFOxgYREZg5lEQ9V06/TAONFYco32p1IIT31rku0Mr75hwk 3Uwyns2wJ/S0axIZ6ewWGD7jCutTpX5xsNRMFpDuceifOVO6YLcRlFirU5MB9AmHI5xaFk2fwKlj SWSr+ltrTDnt6sd+qoYyOaJpiPKOopN5BlckWrqj7soYaHf5nCGgWkjyRjgNZIPVg2p007JrZD5s 7bqvV5KR00hz1TMNVpFd085ixghFG1iL5cWavOZVEWJol3qHz6h7nXK7BdetrRPKLgEBL+NX9ru3 agiaa6vBDNekx5s0LDk7l5q9o5jga1x7kyahsX67MLsWt7JHWIcD4YU6P+itVy2IZsW6UkXa9gXh GKXONKj1XDjFh2OI+3AF3wFckNWlrC5lcAWH+9AushP5nptfFBJ4nklKTKOQNApMs5A0C0mrkLQK SbuQtF1HHV3D5xJ5au06xck09LD8JDtfW5ifWXb/AwAA//8DAFBLAwQKAAAAAAAAACEAd5dwIkED AABBAwAAGgAAAGNsaXBib2FyZC9tZWRpYS9pbWFnZTEucG5niVBORw0KGgoAAAANSUhEUgAAAIsA AAAbCAYAAABMf3y8AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFxEAABcR Acom8z8AAALWSURBVGhD7ZrbrcIwDIY7VwfqCjwzAR2BFzZAFUOwAYIBeEFMkHPSJG2cxIl7j4or 9QW12Pn9+ZIqheCLFSAoUMiL8Bw/wgqIDpbz+Szmum+3G0u7QwUALMfjURwOh0n35XIRr9drh1Lx kgAsEpTT6SSu1+vo+36/i/f7zcruUAEPFgnKlOv7/TIsUwTM+F2GJePg5OYaw5JbRDL2h2HJODi5 ucaw5BaRjP3JHpZHXcqPQaJq1lVxK7vrrnKYte1gaaoWAv+uhM3FVkEj233UogyuoxBl/RgWjdFP N6IyPiyYVZvAYgJRFKUAemqAbJHJQRstdPhFsl0NCwSjD96CsWsd77XUibegwfVh6TIRVhAs1uSg ZQVLG0VVcRYMnrGhTGhAF7S3Oiwm+NQSbcMCswiHralgewvbeoi6tJ+DVS4IqQGgrEXXYIKVJQ6L 619h/18bd9WiPb+x39tE2R0sJkBO+4lUBa/MgvnABaYv/0poCwiQcVaP/w9Uo4douy16sGAVEYEl XBFtQKXvlh+gJYd00r+5YHXa7Q4WIw6tBcGenB58VYB8EFUm97+bzPYqdiPDpy4Y7IjfAwZctKWa Yd92yKli6Xa8V1jQ7PBLDCqSl9GRzNPBULFIZagLSwLwCCxwyx+zayoJkhA1Zf7ZKyzF8MriVQEP Frukh7bkZgagiQrbX6RtYjNL12LMu3G7bvVTyNprSmlGW9eUfcDKA+74mYUMS3I3QBO1r2i0yhIa ouEwPwYWd8aJhZq2rtlgkQeX5HkUecxg7C3PssTOs0zZDYGFYpUl2eK0qInnQPszM0XoHbSyuLua mN1EG6r0B8xoIqwIizwK+Xw+20BPvT+fDw5w1+Ox0t6I2vpSR59Z5I4TDrJhJ2jVzbWLQh6BxR2k Uf9C32Sc39ChfIvd0JTyxO/+hgJ8uv834jzLKhmWWWT8jT9hWH4jzrOssoWFL1aAqsAf5F0B6nY0 vdcAAAAASUVORK5CYIJQSwECLQAUAAYACAAAACEANBL/eBQBAABQAgAAEwAAAAAAAAAAAAAAAAAA AAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAA AAAAAAAAAEUBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQDiO4JlsgEAAPEDAAAfAAAAAAAA AAAAAAAAAC8CAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAh AFNSiWHSAAAAqwEAACoAAAAAAAAAAAAAAAAAHgQAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9k cmF3aW5nMS54bWwucmVsc1BLAQItABQABgAIAAAAIQDqSrIAEAYAALIZAAAaAAAAAAAAAAAAAAAA ADgFAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItAAoAAAAAAAAAIQB3l3AiQQMAAEED AAAaAAAAAAAAAAAAAAAAAIALAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBuZ1BLBQYAAAAABgAG AK8BAAD5DgAAAAA= " o:spid="_x0000_s4101"><v:imagedata o:title="" src="file:///C:\Users\tmesa\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:DefaultSize></x:DefaultSize><x:AutoLine>False</x:AutoLine> <x:CF>Pict</x:CF> <x:MapOCX></x:MapOCX></x:ClientData></v:shape> <TBODY> </TBODY> | ACME COMPANY | $ - | ||||||||||||
<COLGROUP><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3157" width=89><COL style="WIDTH: 148pt; mso-width-source: userset; mso-width-alt: 7025" width=198><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3868" width=109><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4152" width=117><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3356" width=94><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3555" width=100><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3015" width=85><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3527" width=99><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3100" width=87><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2872" width=81><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3527" width=99><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2929" width=82><TBODY>
</TBODY>
