Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread georgemartin812 via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 4:31 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 3:46 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 3:13 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread storeythomas725 via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 2:46 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 2:34 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread spainy via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 2:34 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread libertystringer via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 2:24 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS
On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 1:56 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 11:45 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread libertystringer via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:58 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread libertystringer via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 8:43 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread martinez.david533 via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 8:43 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread cronincarmelita via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 8:08 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 7:25 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread storeythomas725 via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:42 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:32 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:11 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread mintaspriggs via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:49 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:38 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:26 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 12:10 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 12:10 PM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread margaretatolliver via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 11:04 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:54 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:49 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread keisha.fry via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:49 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:48 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:22 AM Thank you so much it's working perf

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread kenyattafreed via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:22 AM Thank you so much it's working perf

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread Sunil Kumar Yadav
Thank you so much it's working perfectly:) On Mar 13, 2017 6:34 PM, "Paul Schreiner" wrote: > What I would do is first load your "Roll No." values into a Dictionary > object. > Then, loop through your "S.No." values and look to see if they are in the > Dictionary. > Report the missing values. >

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:19 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 4:20 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread kenyattafreed via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 3:53 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread cronincarmelita via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 3:35 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 2:54 AM

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread mintaspriggs via MS EXCEL AND VBA MACROS
On Mon, 3/13/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: "excel-macros@googlegroups.com" Date: Monday, March 13, 2017, 3:04 PM What I would do is first load 

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-13 Thread Paul Schreiner
What I would do is first load your "Roll No." values into a Dictionary object.Then, loop through your "S.No." values and look to see if they are in the Dictionary.Report the missing values.Like: Sub Find_Missing()     Dim Dict_SN, SN     Dim nRows, nRow, drow     Set Dict_SN = CreateObject("Scrip