Hey Dear community,
i have command button on sheet1, when used it should get results in sheet2 V5 but it gives results in active sheet only.
Can anybody help me please?
Sub aqua() Dim Markets As Worksheet Set Markets = Sheets("sheet4") Range("A:A").Name = "Urun" Range("L:L").Name = "Sifaris" Range("M:M").Name = "Printed" Markets.Range("c1:c20").Name = "MARKET" Cells(5, "V") = [sum(if((isnumber(match(urun,market,0)))*(sifaris>0),printed))] End Sub
Bookmarks