Instantly create sub cells to add multiple location data

N

NU2XCEL

New Member
Joined
Jun 30, 2013
Messages
1
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?
[TABLE="width: 1027"]
<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>[TR]
[TD="class: xl69, width: 89, bgcolor: transparent"][/TD]
[TD="class: xl72, width: 198, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 109, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 117, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 94, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 100, bgcolor: transparent"][/TD]
[TD="class: xl71, width: 85, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 99, bgcolor: transparent"] [/TD]
[TD="class: xl69, width: 87, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 81, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 99, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 82, bgcolor: transparent"]VOICE PRI[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[TD="class: xl75, bgcolor: transparent"]PRODUCT[/TD]
[TD="class: xl75, bgcolor: transparent"]MRC[/TD]
[TD="class: xl76, bgcolor: transparent"] PRODUCT [/TD]
[TD="class: xl75, bgcolor: transparent"]MRC[/TD]
[TD="class: xl76, bgcolor: transparent"] PRODUCT [/TD]
[TD="class: xl75, bgcolor: transparent"]MRC[/TD]
[TD="class: xl76, bgcolor: transparent"] PRODUCT [/TD]
[TD="class: xl75, bgcolor: transparent"]MRC[/TD]
[TD="class: xl77, bgcolor: transparent"]TOTAL[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]<v:shapetype id=_x0000_t201 path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:path o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"></v:path><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="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+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>
[TD="class: xl69, width: 89, bgcolor: transparent"] [/TD]

</TBODY>
[/TD]
[TD="class: xl78, bgcolor: transparent"]ACME COMPANY[/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"] $ - [/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]
[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You must log in or register to reply here.

Similar threads

S
  • Question Question
Multiple Condition IF/OR Statement with TEXT
Replies
1
Views
983
AlanY
A
H
  • Question Question
Macros - Auto Copy paste row when cell value changes
Replies
7
Views
6K
Fluff
Fluff
N
  • Question Question
How to Create Multiple Reports from One Sheet
Replies
1
Views
2K
Logit
Logit
N
  • Question Question
excel macro to split data into multiple worksheets based on conditions worksheet
Replies
4
Views
4K
Fluff
Fluff
C
  • Question Question
copy entire row based on cell vale
Replies
1
Views
696
MARK858
MARK858

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top