Macro to count the numbers of status in sheet1 against the dealer names of sheet2

Hello Guys,

I need help in creating a Macro which picks the dealer name present in the Sheet2 (“Filtered Data”) and check the same in the Sheet1 (“Database”).

If dealer name found then count the different types of status present against that dealer in “Status” Column and entered the same no. of counts in Sheet2 (“Filtered Data”) in their respective columns.

The same step has to do with “Type” column also of Sheet1 (“Database”).

If any Dealer Name not found in Sheet1 then Macro should move to next Dealer Name.

The Sample sheet has been attached for your reference.

Thanks,

Hi,

You don't really need a macro when you have simple standard Excel functions available. See attached.

If you do really need a macro then I'd simply have the macro enter the formulae in B2 & F2 and copy them down and across their adjacent columns.

Hi,

The following macro will do the same thing. Change the range row refs as appropriate

Please Login or Register  to view this content.