wanna

:)

Hi , I wanna add A with B then store the result in B. thank you

Hey community, i wanna know how can i ask excel to sum if list1 is not on list2 Sheets("DATA").Cells(5, "V") = [sum(if((isnumber(match(list1,list3,0)))*(sifaris>0)*(list1<>list2)*,printed))] Can anybody help me please?

Hello there, I have problem with my formula my brain is stuck and cant find a way to continue. Atm my formula looks like this: =--IF(G6>2999,99;(G6*0,03);IF(G6>1999,99;(G6*0,02);IF(G6>999,99;(G6*0,01);IF(G6>0,01;0)))) In G6 I have positive numbers I wanna make it keep going that way if the...

Hello everyone is there any good excel educational material online? For example if I wanna become an excel specialist than what do I do?

Hello , I Have a Tabel which there are alot of cells , for Example i have 2 cells which i wanna to make a validation rule between them : Account Number & Clearance Code i wanna to create a rule if the clearance code = any value , when i try to write any account number it shows a msg that we...

Hi, this may sound easy but i'm new to vba so i don't know the exact syntax to use... I want to loop throught all Textbox in a userform and wanna perfom a specific command if they are empty or not... the boxes are all named TextBox1, TextBox2, ... so I wanna have acces to the value in it and...

Help !!! i've just received new templates of my reports and i don't have any idea what does it means. the formula says =J9/H9/(J19/H19) .. i wanna know what does H9/(J19 part means. if anyone can help me, i would be very grateful.

Hi guys, Do anyone know how to nest my formula to add another option using AND/OR in my FIND formula, =IF(ISNUMBER(SEARCH("Junior",N2)),"Junior","Adult") This is what I have but I wanna add another criterion: "On campus" and if this is correct it will give me "Junior" Thanks for your help

hello once again and i wanna thank you for the help iam getting in here most helpful forum i found so far i wanna us (IF) function in input a text based on a certain value i have 60 accounts in my program and i want when i make a transaction from cell to another it get written automatic on a...

Hello All, This idea just came to me and I wanna verify if it holds. I wanna dial a phone line through a connected modem by a VBA code. If this is possible please let me know. Thanks Kelly

Hello, I have this file path to access my pictures folder. I am trying to do something a bit weird here: if the first item in a combobox named cmb1 is selected, I wanna use the folder "Picture1", if the second item is selected, then I wanna select the folder "Picture2 " etc. fPath =...

Hello geniuses, I am thinking of something new to me. I wanna get a macro to send sms to contacts in a range. I wanna know if it is possible first. Then I need help how to do it. So it will be like when I click a button, which will be on a userform then send the message "The meeting will be...

Hi Everyone, Can someone assist with my below requirements. 1. I am receiving more than 50 plus mails (excel) in my inbox which consists the same subject called "nata" 2. I just wanna open and consolidate those excels together using vba macro. Is it possible.

Hello, I need another help today too. I have a textbox called txtCurrentUser on a userform. The value in txtCurrentUser could be as: M1Afighter M2Bswimmer M3Cdrummer M4Dpainter M5 crier(contains space) So this is what i wanna do: when the 4th character in txtCurrentUser is say "f", then i...

Hello All, I have this challenge here: i wanna find out if what i am thinking is possible. Then after that i need help with it. So i have a textbox called txtCurrentUser and in this textbox i have username in it. Now i wanna write a script to look at the txtCurrentUser, counting from the left...