Hi I have a question about excel formatting and the table is very close to what my worksheet looks right now. I have been struggling on this for days and I would be really appreciate if someone can help me out. Thanks!
Background:
I have two worksheets, the first one includes massive download data contains different codes:P,A,C,ect. The second worksheet shows only the data with P code. The below table is what my worksheet2 looks like. The formula through A2-D4 is array formula. Cell C5-D5 contains sum formula. Cell A-B is a merged cell for text 'Grand Total". The second worksheet automatically updates any changes made in the first worksheet related to data with P . I replace the current data in worksheet1 with a new download every week.
Question:
The automatic update process stops in worksheet 2 if they reach the grand total row. For example, I have 10 new data this time but my worksheet only has 3 row available(as seen in the table, only row2,3,4 are available)
How do I solve this problem without deleting the grand total row ever ytime or leaving blank rows in my worksheet?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Invoice Number[/TD]
[TD]Shipping Number[/TD]
[TD]Price[/TD]
[TD]Total[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12345[/TD]
[TD]98765[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]23456[/TD]
[TD]87654[/TD]
[TD]20[/TD]
[TD]15[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]34567[/TD]
[TD]65432[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]60[/TD]
[TD]45[/TD]
[TD]P[/TD]
[/TR]
</tbody>[/TABLE]
Background:
I have two worksheets, the first one includes massive download data contains different codes:P,A,C,ect. The second worksheet shows only the data with P code. The below table is what my worksheet2 looks like. The formula through A2-D4 is array formula. Cell C5-D5 contains sum formula. Cell A-B is a merged cell for text 'Grand Total". The second worksheet automatically updates any changes made in the first worksheet related to data with P . I replace the current data in worksheet1 with a new download every week.
Question:
The automatic update process stops in worksheet 2 if they reach the grand total row. For example, I have 10 new data this time but my worksheet only has 3 row available(as seen in the table, only row2,3,4 are available)
How do I solve this problem without deleting the grand total row ever ytime or leaving blank rows in my worksheet?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Invoice Number[/TD]
[TD]Shipping Number[/TD]
[TD]Price[/TD]
[TD]Total[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12345[/TD]
[TD]98765[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]23456[/TD]
[TD]87654[/TD]
[TD]20[/TD]
[TD]15[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]34567[/TD]
[TD]65432[/TD]
[TD]30[/TD]
[TD]25[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]60[/TD]
[TD]45[/TD]
[TD]P[/TD]
[/TR]
</tbody>[/TABLE]