Hi Garima,
No unusual reference, see below.
Number cells must be formatted as text.
Number must contain commas between pairs of numbers before the hundreds
Hi Garima,
No unusual reference, see below.
Number cells must be formatted as text.
Number must contain commas between pairs of numbers before the hundreds
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'