Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi All, I wish to seek your assistance in getting the output as mentioned in the attached excel cell: for Eg: If the Frequency is "High" and the Probability is also "High" I need to get an output of "1" like wise if Frequency is High and Probability is "Medium", I should get an output of "2". T

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi Larit, I tried the macro on a 2500 lines report, it took long time to proceed and reported error, stopped at: ThisWorkbook.Worksheets("Item Master").Range("A1").End(xlDown).Offset(1).Resize(UBound(varShee1Data) + 1) = Application.Transpose(varShee1Data) Can you please help? Thanks, T

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

It works, thanks a lot!!! On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: > > > Hi > > PFA > > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation* > > > > > On Fri, May 4, 2012 at 12:52 AM, Tony Wu wrote

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 12:52 AM, Tony Wu wrote: > Hello, > > I have 2 sheets in one file, one sheet "A" has less part numbers than the > other sheet "B", would