Recent content by madocar

Thank you very much, this helped me a lot!! @p45cal @Belleke

so instead of AND use two IF functions? how would it look like the whole code? thank you in advance

Hello @Monty thank you for your quick answer. Now I get this error: Is there any way how to fix this? Thank you very much Monty in advance

Hello, please is there any way how do I get rid of all TextBoxes in active sheet that are EMPTY via VBA? There's a ton of them and my Excel got frozen. Thank you for any help

@Debaser ! Thank you very much You helped me a lot!

Microsoft 2016 version of 2303

Hi vletm, thank you for replying. K column - we can ignore. Correct formula is with $DA$5#, so: =D5-SUM(((Table_3[Začiatok prenájmu]<=$G$2)*(Table_3[Koniec prenájmu]>=$G$2)*(INDIRECT("'Prenajatá technika'!AL5:"&ADDRESS(ROWS('Prenajatá technika'!$DA$5#)+4;COLUMN('Prenajatá...

Hello, I'm from Slovakia and I use excel in Slovak language. I have set some formulas and when It's open in Czech republic, an error has occured. The formula just does not work at all. Sheet name: Error_sheet Formula Cell: G5 Formula: =D5-SUM(((Table_3[Začiatok...

p45cal, thank you for directing me the right way!! :)

Hello vletm, thank you for your feedback. Yes, I have tried to find a lot of information. But never find any so far. Even in this perfect article there is no information about my case. Probably it's too difficult?

Hello, I would like to ask you if there is any way to solve this: There are 50 working groups in column C Each work group is in a different color background in column C Gantt chart is on right side with conditional formatting I would like to apply the same color background in Gantt chart...

No problem! Thanks you again :)

This is really great! Thanks a lot p45cal Perhaps last question, is there any way how to do it without any macro? Thanks again

It would be nice if you can help me out. Yes, you can count with weekends and holidays. Regarding the example - It was just an example - one and a half day :) Of course it will be more. Thanks a lot for any help

Hi everyone, I would like to ask you if it is possible to show following in a chart: Product: Hour it takes to create: Product A 80 Product B 50 Product C 120 One man daily capacity (this might change dynamically): Daily capacity [Hour] till 15.6.2019 15 till 30.6.2019 10...