avoid

hello I am new to macro and I need your help to create a macro that copy only the data with value > 0 to a new workbook. As you can see from the table, some data have no value so I am trying to avoid copying them by using if condition. Any one can help? see image here https://ibb.co/ettTnx...

Good day experts, I'm using a sumproduct formula =(sumproduct (Handle time * contacts)/(sum contacts) How do I use aggregate with this to avoid hidden rows?

Hello, I had to print my big workbook with a different printer. I had to re-adjust the page setup of more than 20 pages. Except for the printer there should have been no difference (same size, orientation, ... nothing changed) Is there a way to avoid that? What is the reason? Thanks, Michel

Hi Guys, I am currently using windows 7 and excel 2010. I have the following formula in Cell A & Cell B : RANDBETWEEN(0,5) How do I make it so when I press the refresh button the random number chosen would not clash with each other? Example : I want to avoid having 0,0 1,1 2,2 3,3 4,4 5,5...

Hello all, I need help to find a way to use the Small+If structure with multiple criteria inside the If (without creating multiple If). Currently my model works just fine if I have only one argument inside my If. For instance: In here, the range E2:E6 is returning the values that match the...

Hi Gurus.. I have a textbox where I want user to only type in manually and not copy any text from somewhere and paste it into the textbox. How do I disable the paste option when the cursor is in a textbox. This is what I tried and the reason it failed: Private Sub txtPassword_Enter()...