Mar 1, 2009

NUMBER TO WORDS (RUPEES) ADD-IN

Click the following link to download the add-in

KrisUtilities.xla

My thanks to Yogi(SpellIndian), Damon for his UDF showing image in cell and Colo (Menu generator)

VBAs


Listing of Files and Worksheets

http://www.ozgrid.com/forum/showthread.php?t=122285

Match Values Between 2 Sheets, Copy All Corresponding Data & Sum Results

http://www.ozgrid.com/forum/showthread.php?t=133858

Compare 2 Columns For Matches

http://www.ozgrid.com/forum/showthread.php?t=132226

Consolidate Lists From Multiple Sheets Into One

http://www.ozgrid.com/forum/showthread.php?t=132325

Remove Duplicates & Create Word Documents For Each Group

http://www.ozgrid.com/forum/showthread.php?t=126677

List Files & Cell Values With Specific Sheet Names From ListBox

http://www.ozgrid.com/forum/showthread.php?t=123494

Dynamic Charts Based On Mulitple Dynamic Ranges On Different Worksheets

http://www.ozgrid.com/forum/showthread.php?t=124872

Subtotal Rows & Summary Report Of Dynamic Table

http://www.ozgrid.com/forum/showthread.php?t=123001

Delete Named Ranges Specific To 1 Worksheet

http://www.ozgrid.com/forum/showthread.php?t=120437

VBA Macro To Find Bold Cells In User Stated Range

http://www.ozgrid.com/forum/showthread.php?t=120150

Consolidate all worksheets into master workbook

http://www.mrexcel.com/forum/showthread.php?t=369609

Converting multiple rows to single rows

http://www.mrexcel.com/forum/showthread.php?t=368008

Select a filtered Range with vba

http://www.mrexcel.com/forum/showthread.php?t=368027

Write the Text file into the Excel sheet in VBA

http://www.mrexcel.com/forum/showthread.php?t=358515

Find unique values in different spreadsheets

http://www.mrexcel.com/forum/showthread.php?t=357776

Search all Spreadsheets for data

http://www.mrexcel.com/forum/showthread.php?t=357829

Macro for copying cells with specific value in them to another worksheet

http://www.mrexcel.com/forum/showthread.php?t=355538

Importing specific sheet of multiple XLS files into one

http://www.mrexcel.com/forum/showthread.php?t=353721

VBA- delete all defined names beginning "_service"

http://www.mrexcel.com/forum/showthread.php?t=352561

Delete rows with 3 or more semicolons

http://www.mrexcel.com/forum/showthread.php?t=346669

Vba countif visible cells

http://www.mrexcel.com/forum/showthread.php?t=342735



FORMULAs

Create Unique List & Summarize All Associated Values

http://www.ozgrid.com/forum/showthread.php?t=133538

Count Of Unique Numbers Meeting Criteria

http://www.ozgrid.com/forum/showthread.php?t=133012

Shift Work Time Sheet With Normal & Overtime Hours

http://www.ozgrid.com/forum/showthread.php?t=131966

Calculated Weighted & Conditional Average

http://www.ozgrid.com/forum/showthread.php?t=131716

Calculate Increase Based On Criteria

http://www.ozgrid.com/forum/showthread.php?t=130864

Display Related Information By Postcode

http://www.ozgrid.com/forum/showthread.php?t=116922

Average with Special Criteria

http://www.mrexcel.com/forum/showthread.php?t=368077

Sumif with multiple criteria

http://www.mrexcel.com/forum/showthread.php?t=365119

Populate a list box using multiple lookup

http://www.mrexcel.com/forum/showthread.php?t=353912

Transpose

http://www.mrexcel.com/forum/showthread.php?t=353065

Weighted Average Of Filtered Data

http://www.mrexcel.com/forum/showthread.php?t=349685

Largest number starting with "9" in a list

http://www.mrexcel.com/forum/showthread.php?t=347787


Keep visiting..

Oct 9, 2008

VBAs and Formulas posted at OzGrid

Merge Shift Timesheet Files Into Monthly Reports

http://www.ozgrid.com/forum/showthread.php?t=109949

Copy/Special Paste Data Within A Range To Next Empty Cell Then Mark the Copied Area

http://www.ozgrid.com/forum/showthread.php?t=103752

Calculate Weighted Median

http://www.ozgrid.com/forum/showthread.php?t=102065

Pull Each Each Digit From Number Into Single Cells

http://www.ozgrid.com/forum/showthread.php?t=101909

X Condition Lookup

http://www.ozgrid.com/forum/showthread.php?t=101800

Auto-Extending Graph/Chart Range

http://www.ozgrid.com/forum/showthread.php?t=101710

Lookup & Return All Occurences

http://www.ozgrid.com/forum/showthread.php?t=100061

Remove All But 1st Of Duplicate Rows

http://www.ozgrid.com/forum/showthread.php?t=99030

Create A New Worksheet With Specific Cell

http://www.ozgrid.com/forum/showthread.php?t=98949

Reference Cell In Macro Using Row & Column Numbers From Cell

http://www.ozgrid.com/forum/showthread.php?t=98948

Concatenate Each Row To Cells In Column

http://www.ozgrid.com/forum/showthread.php?t=98718

Colour Cells Conditionally From Formula

http://www.ozgrid.com/forum/showthread.php?t=98631

Add Missing Leading Zeros To Text

http://www.ozgrid.com/forum/showthread.php?t=98627

Filter Named Range To Userform ListBox

http://www.ozgrid.com/forum/showthread.php?t=98624

Conditional Percentage Calculation

http://www.ozgrid.com/forum/showthread.php?t=98459

Concatenating Many Columns To One

http://www.ozgrid.com/forum/showthread.php?t=98406

Quartile Function In VBA

http://www.ozgrid.com/forum/showthread.php?t=98152

Sum Range Defined By Reference Cell

http://www.ozgrid.com/forum/showthread.php?t=98147

Sum If With Multiple Criteria

http://www.ozgrid.com/forum/showthread.php?t=98140

Return All Results Corresponding To Lookup Value

http://www.ozgrid.com/forum/showthread.php?t=90243

Lookup Value Across Multiple Worksheets

http://www.ozgrid.com/forum/showthread.php?t=89679

Subtotal Filtered Column By Criteria

http://www.ozgrid.com/forum/showthread.php?t=89215

Lookup & Return Adjacent Value From Left

http://www.ozgrid.com/forum/showthread.php?t=87509

Separate Comma Delimited Cells To New Rows

http://www.ozgrid.com/forum/showthread.php?t=87390

Lookup Two Values In A List And Return Multiple Corresponding Values

http://www.ozgrid.com/forum/showthread.php?t=87166

Compare Ranges And Delete Duplicates

http://www.ozgrid.com/forum/showthread.php?t=87414

2 Criteria Lookup Without #N/A

http://www.ozgrid.com/forum/showthread.php?t=87381

Keep EXCELling

Jul 12, 2007

General

Userid And Password To Access Worksheets
http://www.ozgrid.com/forum/showthread.php?t=73749


Yearly Calendar
http://www.ozgrid.com/forum/showthread.php?t=58028


Dynamic Chart
http://www.ozgrid.com/forum/showthread.php?t=58206


List of All Excel Functions
http://www.mrexcel.com/board2/viewtopic.php?t=230815

VBAs

Merge, Sort & Eliminate Close Duplicates
http://www.ozgrid.com/forum/showthread.php?t=73401

Match Data from 2 Sheets and Results in 3rd Sheet
http://www.ozgrid.com/forum/showthread.php?t=72681

Remove zeros only
http://www.ozgrid.com/forum/showthread.php?t=72623

Check and Append data in Cells
http://www.ozgrid.com/forum/showthread.php?t=72270

Countif with SpecialCells
http://www.ozgrid.com/forum/showthread.php?t=71997

Count Most Frequent Values in a Cell
http://www.mrexcel.com/board2/viewtopic.php?t=269509

Add Unique Items in Combobox
http://www.mrexcel.com/board2/viewtopic.php?t=271120

Distribute 35000 Rows equally into 6 different excel sheets
http://www.mrexcel.com/board2/viewtopic.php?t=254762

Create Unique Words
http://www.mrexcel.com/board2/viewtopic.php?t=249267

Delete Rows Meeting Criteria or Condition
http://www.ozgrid.com/forum/showpost.php?p=312532&postcount=5

Retain Leading Zero in Custom Format
http://www.ozgrid.com/forum/showpost.php?p=313474&postcount=4

Add X Rows Between Each List Item
http://www.ozgrid.com/forum/showthread.php?t=61058

List All Worksheet Names
http://www.ozgrid.com/forum/showthread.php?t=61138

Match Cells And Sum
http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14

Scanning Schedule
http://www.mrexcel.com/board2/viewtopic.php?t=246085

Unmerge and Fill Blank Cells
http://www.mrexcel.com/board2/viewtopic.php?t=246451

Filter by Background Color
http://www.mrexcel.com/board2/viewtopic.php?t=240068

Insert Rows
http://www.mrexcel.com/board2/viewtopic.php?t=238604

Transpose Data from Columns to Rows
http://www.mrexcel.com/board2/viewtopic.php?t=238917

Consolidate Data from Many Files to Single File
http://www.mrexcel.com/board2/viewtopic.php?t=235229

Change Sheet Name
http://www.ozgrid.com/forum/showthread.php?t=56781

Clear Old Pivot Items
http://www.ozgrid.com/forum/showthread.php?t=56885

Match Data from 2 Sheets and Results in 3rd Sheet
http://www.ozgrid.com/forum/showthread.php?t=72681

Remove zeros only
http://www.ozgrid.com/forum/showthread.php?t=72623

Check and Append data in Cells
http://www.ozgrid.com/forum/showthread.php?t=72270

Countif with SpecialCells
http://www.ozgrid.com/forum/showthread.php?t=71997

Count Most Frequent Values in a Cell
http://www.mrexcel.com/board2/viewtopic.php?t=269509

Add Unique Items in Combobox
http://www.mrexcel.com/board2/viewtopic.php?t=271120

Distribute 35000 Rows equally into 6 different excel sheets
http://www.mrexcel.com/board2/viewtopic.php?t=254762

Create Unique Words
http://www.mrexcel.com/board2/viewtopic.php?t=249267

Autofilter By Color
http://www.ozgrid.com/forum/showthread.php?t=59611

Move Data from 1 to Multiple Columns
http://www.ozgrid.com/forum/showthread.php?t=59106

Formulas

Formulas..

Count Occurence of 2 variables
http://www.ozgrid.com/forum/showthread.php?t=72647

Lookup Minimun with Criteria
http://www.ozgrid.com/forum/showthread.php?t=72481

Convert Date to Quarter
http://www.ozgrid.com/forum/showthread.php?t=72428

Count Unique Items in Autofilter
http://www.ozgrid.com/forum/showthread.php?t=70131

Split Text over x characters
http://www.ozgrid.com/forum/showthread.php?t=71850

Dual Headings Match
http://www.ozgrid.com/forum/showthread.php?t=71471

Convert Letter Grade to Numbers
http://www.ozgrid.com/forum/showthread.php?t=71469

Split Varying Lenght of Text
http://www.mrexcel.com/board2/viewtopic.php?t=281367

Lookup with Multiple results
http://www.ozgrid.com/forum/showthread.php?t=70050

Roundup to Nearest x
http://www.ozgrid.com/forum/showthread.php?t=70107

Index Match Function For Two Same Values
http://www.ozgrid.com/forum/showthread.php?t=70267

Extracting Subtotal Results
http://www.ozgrid.com/forum/showthread.php?t=69791

Vlookup Cell Containing Symbol & Text
http://www.ozgrid.com/forum/showthread.php?t=69610

Find first positive value
http://www.mrexcel.com/board2/viewtopic.php?t=275007

Last Text & Numeric Entry in Dynamic Range
http://www.ozgrid.com/forum/showthread.php?t=68869

Split Text
http://www.ozgrid.com/forum/showthread.php?t=60226

Convert Decimal to Feet & Inches
http://www.ozgrid.com/forum/showpost.php?p=311731&postcount=19

Find Nos. In Strings
http://www.ozgrid.com/forum/showpost.php?p=312542&postcount=3

Copy Unique Lists
http://www.ozgrid.com/forum/showthread.php?t=60309

Convert Date with Dot Separated
http://www.ozgrid.com/forum/showpost.php?p=311790&postcount=10

Take Value to Left of Max Value in a Column
http://www.ozgrid.com/forum/showthread.php?t=60519

Highlight Array Formulas in Range
http://www.ozgrid.com/forum/showthread.php?t=55433

Lookup on Multiple Sheets
http://www.ozgrid.com/forum/showthread.php?t=60681

Phone Number Splitting
http://www.ozgrid.com/forum/showpost.php?p=313634&postcount=6

Lookup Transposed Table
http://www.ozgrid.com/forum/showthread.php?t=60822

Count Numbers In Sequence
http://www.ozgrid.com/forum/showpost.php?p=316909&postcount=8

Return Value After Matching Two Variables
http://www.ozgrid.com/forum/showthread.php?t=61412

Show Nth Day of Month
http://www.ozgrid.com/forum/showpost.php?p=317454&postcount=4

Date Formula Based on Other Dates
http://www.ozgrid.com/forum/showthread.php?t=61679

http://www.ozgrid.com/forum/showpost.php?p=319433&postcount=14

http://www.ozgrid.com/forum/showthread.php?t=61880

Sort By Lookup & Ranking
http://www.ozgrid.com/forum/showthread.php?t=61857

Sum Range Using 1 Column of Named Range as Criteria
http://www.ozgrid.com/forum/showthread.php?t=61929

Adding Cell Names
http://www.mrexcel.com/board2/viewtopic.php?t=246234

Return Row No. of Top 3 Values
http://www.mrexcel.com/board2/viewtopic.php?t=248288

Counting No. of Different Instances
http://www.mrexcel.com/board2/viewtopic.php?t=246432

Formatting Phone Numbers
http://www.mrexcel.com/board2/viewtopic.php?t=242707

Find Last Non-zero Value
http://www.mrexcel.com/board2/viewtopic.php?t=241778

Scroll Area Limit
http://www.mrexcel.com/board2/viewtopic.php?t=240865

Count Words with All Caps
http://www.mrexcel.com/board2/viewtopic.php?t=237290

Extract Data from String
http://www.mrexcel.com/board2/viewtopic.php?t=236351

Sum Alphanumerics
http://www.ozgrid.com/forum/showthread.php?t=60111

Match Multiple Criteria
http://www.ozgrid.com/forum/showthread.php?t=60019

Extract Digits From Text
http://www.ozgrid.com/forum/showthread.php?t=60076

Dynamic Range Formula
http://www.ozgrid.com/forum/showthread.php?t=59919

Sum Values based on Text
http://www.ozgrid.com/forum/showthread.php?t=59855

Calculate Financial Year
http://www.ozgrid.com/forum/showthread.php?t=59901

Return Lowest Based on Text
http://www.ozgrid.com/forum/showthread.php?t=59818

Find Last Values and Sum
http://www.ozgrid.com/forum/showthread.php?t=59744

Delete Duplicates Except Last
http://www.ozgrid.com/forum/showthread.php?t=59705

Lookup on Multiple Sheets
http://www.ozgrid.com/forum/showthread.php?t=59341

Last Name, First Name
http://www.ozgrid.com/forum/showthread.php?t=59127

Bring Sum into a Single Digit
http://www.ozgrid.com/forum/showthread.php?t=58770

Transpose Columns Data into Single Column
http://www.ozgrid.com/forum/showthread.php?t=58549

Convert yyyymmdd to dd-mm-yyyy
http://www.ozgrid.com/forum/showthread.php?t=58317

List Sheet Names
http://www.ozgrid.com/forum/showthread.php?t=58897

Splitting Address to Multiple Cells
http://www.ozgrid.com/forum/showthread.php?t=58851

Match Data and Split
http://www.ozgrid.com/forum/showthread.php?t=58393

DSUM
http://www.ozgrid.com/forum/showthread.php?t=57491

Extract Text Between Characters
http://www.ozgrid.com/forum/showthread.php?t=57416

SUMIF on Badly Laid out Data
http://www.ozgrid.com/forum/showthread.php?t=57079

Weighted Average on Filtered Data
http://www.ozgrid.com/forum/showthread.php?t=57169

Extracting Data Within Parentheses
http://www.ozgrid.com/forum/showthread.php?t=57265

Average Fixed Intervals In A Large Column Of Data
http://www.ozgrid.com/forum/showthread.php?t=57266

Count Times Between 2 Specified Times
http://www.ozgrid.com/forum/showthread.php?t=57260

Count of Duplicate Entries
http://www.ozgrid.com/forum/showthread.php?t=57232

Extract Letters from Cell
http://www.mrexcel.com/board2/viewtopic.php?t=232227

Count Occurence of 2 variables
http://www.ozgrid.com/forum/showthread.php?t=72647

Lookup Minimun with Criteria
http://www.ozgrid.com/forum/showthread.php?t=72481

Convert Date to Quarter
http://www.ozgrid.com/forum/showthread.php?t=72428

Count Unique Items in Autofilter
http://www.ozgrid.com/forum/showthread.php?t=70131

Split Text over x characters
http://www.ozgrid.com/forum/showthread.php?t=71850

Dual Headings Match
http://www.ozgrid.com/forum/showthread.php?t=71471

Convert Letter Grade to Numbers
http://www.ozgrid.com/forum/showthread.php?t=71469

Split Varying Lenght of Text
http://www.mrexcel.com/board2/viewtopic.php?t=281367

Lookup with Multiple results
http://www.ozgrid.com/forum/showthread.php?t=70050

Roundup to Nearest x
http://www.ozgrid.com/forum/showthread.php?t=70107

Index Match Function For Two Same Values
http://www.ozgrid.com/forum/showthread.php?t=70267

Weeknum to Date
http://www.ozgrid.com/forum/showthread.php?t=56784

Commission Formula
http://www.ozgrid.com/forum/showthread.php?t=56891

Lookup Based on 2 Criteria
http://www.ozgrid.com/forum/showthread.php?t=56835

Lookup
http://www.ozgrid.com/forum/showthread.php?t=56827

2 Dimensional Lookup
http://www.ozgrid.com/forum/showthread.php?t=56964

Sum with Multiple Criteria
http://www.mrexcel.com/board2/viewtopic.php?t=231395

Countif with a Twist
http://www.mrexcel.com/board2/viewtopic.php?t=230845

Count Days Excluding SUnday
http://www.mrexcel.com/board2/viewtopic.php?t=230749

Lookup With Multiple Results
http://www.mrexcel.com/board2/viewtopic.php?t=231144

Extracting Subtotal Results
http://www.ozgrid.com/forum/showthread.php?t=69791

Vlookup Cell Containing Symbol & Text
http://www.ozgrid.com/forum/showthread.php?t=69610

Find first positive value
http://www.mrexcel.com/board2/viewtopic.php?t=275007

Last Text & Numeric Entry in Dynamic Range
http://www.ozgrid.com/forum/showthread.php?t=68869