Error showing if range contain different series

Hi members,

I got below vba code from Master xld (vbaexpress).


In Raw Data Sheet

Branch code in column A
Documents numbers in column b

Given VBA code is calculating From & To document numbers for each branch in Output sheet.
The code is working fine. But below points should be improve

• If any branch contain more than one series then this code giving error.
• If missing numbers are more that one these all numbers not showing.
• If any branch has only one document number it is showing missing same.

Please Login or Register  to view this content.

Here I have attached file with desired output.

This thread is alive @ http://www.vbaexpress.com/forum/show...in-given-range But there is not response since 2-3 days.

Thanks in advance

Hi, satputenandkumar0,

you should point out that the thread is kept alive from you at VBA Express: http://www.vbaexpress.com/forum/show...in-given-range.

Ciao,
Holger

Sir, there is no response since 2-3 days. ( Point added in OP)

Dear Forum Gurus

Anybody have Solution for this or Formula instead of vba code ??

bump post .

bump post........

Any Body has Idea?