1. To add only the colored cells in excel add the following coding in the macro window:
Function sumcolor(selcel As Range)
Dim Cell As Object
Dim x As Double
x = 0
For Each Cell In selcel
If Cell.Interior.ColorIndex = -4142 Or Cell.Interior.ColorIndex = 2 Then
Else
x = x + Cell.Value
End If
Next Cell
sumcolor = x
End Function
An Example:
-Google Docs
-Mediafire Link
2. Display Amount in Indian Rupees Format, i.e., in Crores in Excel.
Function sumcolor(selcel As Range)
Dim Cell As Object
Dim x As Double
x = 0
For Each Cell In selcel
If Cell.Interior.ColorIndex = -4142 Or Cell.Interior.ColorIndex = 2 Then
Else
x = x + Cell.Value
End If
Next Cell
sumcolor = x
End Function
An Example:
-Google Docs
-Mediafire Link
----------------------------------------------------------------------------------------------------
2. Display Amount in Indian Rupees Format, i.e., in Crores in Excel.
- Select the desired cells
- Press Ctrl + 1
- Select Custom Number format
- Paste this in the 'Type:' textbox - [>=10000000]##","##","##","##0.00;[>=100000]##","##","##0.00;#,##0.00
thanks ram really great work
ReplyDeleteVERY NICE RAM JI !! GOOD WORK !!
ReplyDeleteHello Sir, can you provide excel sheet to add bank statement to tally via excel
ReplyDeleteIts Useful..
ReplyDeleteHello Thank you Nice work
ReplyDeleteHELLO SIR
ReplyDeletePLS UPDATE TALLY AUTO ENTRY
fantaisc works sir
ReplyDeletehi excel which version?
ReplyDeletei need invetory excell to Tally
ReplyDelete