Macro to Format Cell Borders

[zaska]

Hi,

I want to format bottom doubleborder for all the cells having = sum() formula . How can i achieve this with End structure

Thank you

 

[zaska]

Bump

 

[zaska]

The code is not working as i intended for

[COLOR=Red]  Cells.Replace "=SUM(", "=XXXSUM(", xlPart[/COLOR]   </pre>

If i have formula = A1+B1 then also this code is converting it to xxxsum.But I need to modify only those cells which contain formula as = SUM(xxxx+yyy).

Please give any input on this problem

Thank u

 

[zaska]

The code is not working as i intended for

[COLOR=Red]  Cells.Replace "=SUM(", "=XXXSUM(", xlPart[/COLOR]

If i have formula = A1+B1 then also this code is converting it to xxxsum.But I need to modify only those cells which contain formula as = SUM(xxxx+yyy).

Please give any input on this problem

Thank u

bump

 

[ka_123!]

why not to keep it simple :

Select the whole data
Press Ctrl+t
problem is solved

IF you further want to make tables of your own click anywhere on table then simply go t0


Table Tools >Design>table style>New table style

 

[Rick Rothstein]

bump

Sorry about the delay in getting back to you (needed to sleep, you know). Does this do what you want?

Sub DoubleUnderlineSumFormulas()
  Dim Cell As Range
  Const Headers As String = "A1:D1"
  Application.ScreenUpdating = False
  With Range(Headers)
    .Font.Bold = True
    .HorizontalAlignment = xlHAlignCenter
    .VerticalAlignment = xlVAlignCenter
  End With
  Cells.Replace "=SUM(", "=XXXSUM(", xlPart
  For Each Cell In Cells.SpecialCells(xlFormulas, xlErrors)
    If InStr(Cell.Formula, "=XXXSUM(") Then
      Cell.Borders(xlEdgeTop).LineStyle = xlContinuous
      Cell.Borders(xlEdgeBottom).LineStyle = xlDouble
      Cell.Font.Bold = True
      Cell.NumberFormat = "#,##0.00"
    End If
  Next
  Cells.Replace "=XXXSUM(", "=SUM(", xlPart
  Application.ScreenUpdating = True
End Sub

 

[zaska]

I am sorry for not waiting patiently till your message and thank you very much as "=sum" problem got resolved. However the Header Part , The number format of Cells which doesn't contain "=SUM" Formula and the Borders for the Cells which doesn't contain "=SUM" Formula didn't get resolved.

To be in Brief i am trying to format a Balance Sheet and Trading & Profit & loss A/c using VBA Code.

As you can see in the below sample date the Header always has the wording's Trading & Profit & Loss Account.....or Balance Sheet ...Expenditure...Amount...Income...etc...

Can i have the same No. Format for the remaining values which doesn't contain "=SUM" However some values may contain formula as "A1+A2"

I also want to have borders for the selected Balance sheet or P&L A/c in the below manner.

There are also subheadings in the data which are like : Direct Expenses , Indirect Expenses etc...(Which doesn't have corresponding Numerical Values). I want to Bold These Subheadings in Italics and Add ":-"

Thank you and take your own time

Sample Data

<table border="0" cellpadding="0" cellspacing="0" width="646"><tbody><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;width:207pt; font-size:10.0pt;color:white;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Arial;border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid windowtext;border-left:.5pt solid #95B3D7; background:#4F81BD;mso-pattern:#4F81BD none" height="17" width="276">Trading & Profit & Loss Account for the Year Ended 31-03-2008</td> <td class="xl76" style="width:69pt;font-size:10.0pt;color:white; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid windowtext;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" width="92">Column1</td> <td class="xl76" style="width:140pt;font-size:10.0pt;color:white; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid windowtext;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" width="187">Column2</td> <td class="xl76" style="width:68pt;font-size:10.0pt;color:white; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:.5pt solid #95B3D7; border-bottom:.5pt solid windowtext;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" width="91">Column3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl64" style="height:12.75pt;border-top:none;font-size: 10.0pt;color:black;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Arial;border:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Expenditure</td> <td class="xl65" style="border-top:none;font-size:10.0pt;color:black; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid windowtext;border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none">Amount</td> <td class="xl65" style="border-top:none;font-size:10.0pt;color:black; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid windowtext;border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none">Income</td> <td class="xl65" style="border-top:none;font-size:10.0pt;color:black; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid windowtext;border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none">Amount</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Opening Stock</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">100.00</td> <td class="xl68" style="font-size:10.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">Direct Incomes :-
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl69" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Direct Expenses :-
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl70" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">Development Expenses Received</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">100.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Land Cost</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">200.00</td> <td class="xl70" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Layout Expenses</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">300.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">closing stock</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">400.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Gross Profit</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">400.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl72" style="height:13.5pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="18">
</td> <td class="xl73" style="border-left:none;font-size:10.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid windowtext; border-right:.5pt solid windowtext;border-bottom:2.0pt double windowtext; border-left:.5pt solid windowtext" align="right">900.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl73" style="border-left:none;font-size:10.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid windowtext; border-right:.5pt solid windowtext;border-bottom:2.0pt double windowtext; border-left:.5pt solid windowtext" align="right">500.00</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl72" style="height:13.5pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="18">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">Gross Profit</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">500.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl69" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Indirect Expenses :-
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl68" style="font-size:10.0pt;color:black;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">Indirect Incomes :-
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Bank Charges</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">100.00</td> <td class="xl70" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">Agricultural Income</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">600.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Car Insurance</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">200.00</td> <td class="xl70" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">Commission</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">400.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Electrical Charges</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">300.00</td> <td class="xl70" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">Dividend From Shares</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">700.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Genaral Expenses</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">400.00</td> <td class="xl70" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">500.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Interest on Car Loan</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">500.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Repairs & Maintenance</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">600.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Salares Paid</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">700.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">Telephone Charges</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none" align="right">800.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl66" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext" height="17">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl72" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="17">Net Profit</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" align="right">-900.00</td> <td class="xl71" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl74" style="height:13.5pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid windowtext;border-left:.5pt solid windowtext" height="18">
</td> <td class="xl73" style="border-left:none;font-size:10.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid windowtext; border-right:.5pt solid windowtext;border-bottom:2.0pt double windowtext; border-left:.5pt solid windowtext" align="right">2,700.00</td> <td class="xl75" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid windowtext;border-bottom:.5pt solid windowtext;border-left:none">
</td> <td class="xl73" style="border-left:none;font-size:10.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid windowtext; border-right:.5pt solid windowtext;border-bottom:2.0pt double windowtext; border-left:.5pt solid windowtext" align="right">2,700.00</td> </tr> </tbody></table>
Regards,

Zaska

 

[Rick Rothstein]

Okay, the Sample Data table you showed us is the "after the code" result... can you show us the "before the code" setup for that same Sample Data table so I can see what changed? Also, can you number the rows so I can be sure which headings is where? Also, is all your data always arranged a column of text followed by a column of numbers followed by a column of text followed by a column of numbers and so on? Also are there any blank columns in between any of those columns?

 

[zaska]

Sir,

Sample Data Before Formatting Table was Inserted Only for pasting a Snap Shot Here) and i couldn't merge Header " Trading & Profit ...." with
other Columns.



<table border="0" cellpadding="0" cellspacing="0" width="484"><colgroup><col style="mso-width-source:userset;mso-width-alt:5156;width:106pt" width="141"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:6838;width:140pt" width="187"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody><tr style="height:51.0pt" height="68"> <td class="xl71" style="height:51.0pt;width:106pt; font-size:10.0pt;color:white;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Arial;border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#4F81BD;mso-pattern:#4F81BD none" height="68" width="141">Trading & Profit & Loss Account for the Year Ended 31-03-2008</td> <td class="xl71" style="width:59pt;font-size:10.0pt;color:white; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid #95B3D7;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" width="78">Column2</td> <td class="xl71" style="width:140pt;font-size:10.0pt;color:white; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid #95B3D7;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" width="187">Column3</td> <td class="xl71" style="width:59pt;font-size:10.0pt;color:white; font-weight:700;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:.5pt solid #95B3D7; border-bottom:.5pt solid #95B3D7;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" width="78">Column4</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl65" style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none">
</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl65" style="font-size:11.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:.5pt solid #95B3D7;border-right:.5pt solid #95B3D7; border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Arial;border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Expenditure</td> <td class="xl66" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">Amount</td> <td class="xl66" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:none; border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Income</td> <td class="xl66" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Arial;border-top:.5pt solid #95B3D7;border-right:.5pt solid #95B3D7; border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">Amount</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Opening Stock</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">100</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Direct Incomes </td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Direct Expenses </td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">
</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Development Expenses Received</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">100</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Land Cost</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">200</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Layout Expenses</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">300</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">
</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">closing stock</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">400</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Gross Profit</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">400</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">900</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">500</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">
</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Gross Profit</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">500</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Indirect Expenses </td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">
</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Indirect Incomes </td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Bank Charges</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">100</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Agricultural Income</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">600</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Car Insurance</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">200</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Commission</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">400</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Electrical Charges</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">300</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">Dividend From Shares</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">700</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Genaral Expenses</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">400</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">500</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Interest on Car Loan</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">500</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Repairs & Maintenance</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">600</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Salares Paid</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">700</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Telephone Charges</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">800</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">
</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">
</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl67" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl69" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">Net Profit</td> <td class="xl70" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">-900</td> <td class="xl69" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl69" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;width:106pt; font-size:10.0pt;color:black;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7; border-right:none;border-bottom:.5pt solid #95B3D7;border-left:.5pt solid #95B3D7; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20" width="141">
</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="78">2700</td> <td class="xl67" style="width:140pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: none;border-bottom:.5pt solid #95B3D7;border-left:none;background:#DCE6F1; mso-pattern:#DCE6F1 none" width="187">
</td> <td class="xl68" style="width:59pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Times New Roman";border-top:.5pt solid #95B3D7;border-right: .5pt solid #95B3D7;border-bottom:.5pt solid #95B3D7;border-left:none; background:#DCE6F1;mso-pattern:#DCE6F1 none" width="78">2700</td> </tr> </tbody></table>
I couldn't name the Rows for Headers as they change everytime. But I think of some thing like this for the header Part.

If Not Cell.Hasformula Then
For Each Cell In Selection
If Cell.Text = " Trading & Profit & loss..." , "Expenses","Amount","Income","BalanceSheet..." then Bold The Header , Merger the First Row and Centre the Second Row.

( If Header Part is too difficult to code then you may ignore the same as it not so important and i can do it manually )

2. Yes the columns are always arranged in the same manner...Text followed by values , Text Followed by values...and there may be a One Column or Two Column gap between P&L A/c and Balance sheet .

3. The Formatting part is all about

a. Select the Entire Sheet

b. Bold and Centre the Header Part where ever it is found in the sheet

c. Change the Number format to " #,##0.00" irrespective of whether the cell has "=Sum()" formula or "=A1+B1...etc.."or even doesn't has a formula

d. Change the Border of "=Sum()cells " as xldouble ( Already coded)

e. Change the Subheadings to Italics , Bold them and add " :- " ( i.e This text in the P&L a/c doesn't have correspoinding numerical figures) Example...Indirect Incomes...Direct Incomes etc...

f. Insert a single space for Before Text figures ...Example

g. Apply normal border for the remaing values and text excluding " =Sum()" cells..( Manually I select Each column and Presss Ctrl + Shft + & )

Thank you for your kind help

 

[Rick Rothstein]

I couldn't name the Rows for Headers as they change everytime.QUOTE]
Using your posted sample data as an example, do you mean the row with Expenditure, Amount, Income and Amount is not always located on a known row? If that is the case, then are all the rows above it always blank, except for the first row (which I presume always has the Profit & Loss header on it)?

2. Yes the columns are always arranged in the same manner...Text followed by values , Text Followed by values...and there may be a One Column or Two Column gap between P&L A/c and Balance sheet .

Do you mean you have more than one table on the same sheet separated by one or two empty columns?

3. The Formatting part is all about

f. Insert a single space for Before Text figures ...Example

Your example did not come through so I am not sure what you mean by this. Is it on your sample data somewhere?

 

[zaska]

Sir,

If you don't mind i have uploaded the sample excel file which has both before and after data

http://www.sendspace.com/file/b8y1cx ( I assure that the file doesn't contain any Macros)

Yes The Row Number is not always constant ..it depends on how long the name of the company and it's addrees and city name are.

and i have Two Financial Statements separated by one or Two Column Gaps.

1. Profit and Loss Account ( followed by Expenditure , Amount , Income , Amount)
2. Balance Sheet ( followed by Liabilities , Amount , Assets , Amount)

I don't have any Tables inserted in my Excel Sheets..I did insert tables so that i could paste a sample data here without html code.

I have inserted a single spcace before entering text in every cell but the same was not there in the sample data. ( you may ignore this part for now)

If anything is not still clear plz send your comments.

Thankyou