Search results

Hello, I would like to ask that how is it possible return blank cell if the result of worksheet function is 0? With Sheets("Evaluation") Lastrow = .Cells(.Rows.count, "B").End(xlUp).Row .Range("AN9:AP" & Lastrow).ClearContents .Range("AN9:AN" & Lastrow) =...

Thank you Deepak, you solved my problem and were very helpful with me!

we are very close but if I write 100 into sheet MAV!M17 then the formula give back 0 on sheet DDD!O17

It is almost good but if the formula find 0 value then it should display.

Hello Deepak, On my PC the formula still represent 0 value instead of blank cell.

Hello, I would need you advice regarding blank cell displaying. In my sample file I search the target value based on 2 criterias, it is working fine but if the formula doesn't find anything then turn to 0. i would like that if the formula doesn't find anything then turn to blank cell instead...

Hi Narayan, Tha code want to give too many series to the chart (I do not know why), but if I just delete the unnecessary series then I receive the expected result. The problem solved. With ActiveChart Do Until .SeriesCollection.Count = 0 .SeriesCollection(1).Delete Loop End With...

Hi Narayan, Thank you for your time, the problem is still open.

Hello, I would like to ask some help from you regarding the chart updating. I use this code to create chart about the data source: Sub WeeklyChart() Dim SourceSheet1 As Worksheet Dim SourceLastrow1 As Long Dim cht2 As Chart Set SourceSheet1 = Worksheets("Evaluation") With SourceSheet1...

Hello Hui, Thank you the help!

Hello, I would like to ask some help to create a chart based on the given data (you can see in the sample file). To represent the desired result I just colored the background of the cells. Thank you in advance the reply!

Do you have some idea?

Got it, thanks.

Hello, I use the below mentioned part of code to send mail with reminder but my problem is that regarding the reminder: How to set the next calendar working day? Could you please give some advice how should I set this? With OutMail .To = "" .CC = "" .BCC = "" .Subject = "" &...

Hi Marc L, Thank you for your attention, could you please give me bit more direction, my knowledge is pour regarding this.

Hello, I would need your help regarding jpg creating. My question would be that: how is it possible to set the range until: ("A1:AP" & Lastrow)? In my file the content of this range is changing each day therefore I would like to handle "dynamically"... somehow. This the code what I have now...

Hi Narayan, Thank you the help!

Hi Nebu, Yes, you are right. The pivot table would be a good solution. Just I have to keep the current data layout and to add pivot table is not allowed. :(

Hello, I struggle with big data and I do not see the light the end of tunnel. In my sample file I would like to calculate the monthly inventory value by distinct company and material the code is working fine just the problem is that the total calculation time is: 20 sec. :eek: The original...

Hi Narayan, Thank you for your time. Maybe I was not enough clear, I do not want to switch the position of row and column labels. The "Material" has to be row label always, and the "Date/week" has to be column label always as well. My problem is that after I refresh (with new set of data) the...

Hello, I would like to ask that is there any kind of way to display all column labels of pivot table and then sort them by ascending order thru VBA (after refreshing)?

Hi Narayan, This is what I exactly need! Thank you the help!

Hello, I would like to ask some help regarding a rounding issue. In my sample the target is that to display rounded the values (which are in the Pivot table) based on the packaging rules but I can not figure out how should do it. Could somebody help me? Thanks in advance the reply!

You are AWESOME Marc L!

Hello, Thank you the help! @Marc L Could you please show me an example how to do it? @Narayan Is it possible to count without helper columns?