hope

Hi all, Hope you can help me, i have been trying to find the answer but just cant seem to find it. I have a column of cells and each contains a date and a time. There are 2 options for what i want to display. 1. Highlight a cell in green if it has a date and time in the future of the...

Hi all, I hope someone can help or point me in the wright direction. I have a book which I'm building and one of the sheets contains the out comes of the user input, so the formulas on this page are =IF(AND(....=IF(OR... etc and there are a lot of them! So I thought I could place quite a few...

Hello, I've been working with a series of Macros for a little while now. I've been setting up little buttons on a page so they are accessible to a user. It occurred to me how much easier it would be to just create a macro and add it to a ribbon. And it's pretty amazing to have. There is one...

hi all, I am hoping this is possible but need some more experienced help. I hope this makes sense. I am trying to find out if there is a way (using formulas) to look for any value greater than 100 in column N and put the numbers into column BB in column N almost every second line has a number...

Im trying to have a the excel sheet pull in a list depending on what is selected in another list. The idea is to have a dropdown in D1 of two list depending on that value the information updates in D5 (roles).. Driving me nuts hope someone can understand what im trying to do and help. Fingers...

Greetings - Can COUNTVISBLE be used in conjunction with an operator like > When I filter rows, I would like a formula that counts only some of the rows. I hope that makes sense. Thanks in advance.

I wanted to run a macro that would perform a find and replace function across workbooks in multiple subfolders. I also wanted it to exclude certain named folders. I cobbled together something that would do this, which may be of use, which you can find here. Please note that it will not search...

Hi i hope you can help, i am tring to add the data entered into 'ComboBox2' into my subject heading in an email, i have tried the below code but i get an error, i really hope you can help me? thanks for your time. aEmail.Subject = Range("ComboBox2").Value

I'm entering the following function, but it is not working: =IF(AND(E6,G6,H6,I6,J6,L6,M6,N6,O6="yes",F6,K6="no"),"400","0") If cells E6, G6, H6, I6, J6, L6, M6, N6, O6 equal "yes" and cells F6, K6 = "no" then return $400 otherwise return 0. I hope this makes sense. Any help is hugely...

Hi I have alot of data, that i need to convert. <tbody> value in system new value (the formula that i need) 8726,36 9000 8971,84 9000 56724,62 57000 7000,1 9000 846618,09 847000 </tbody> what i got so fare is =ROUNDUP(ODD((ROUNDUP(R3;-3)));-3) but it doesnt work i need the...

I thought it would be rude to just pop in with a question and no introduction... so I thought I'd come to the Lounge and say hi. HI! I'm from Texas and I am new to this whole Excel VBA thing with my current project. It's definitely interesting and I hope it leads to bigger and better ones...

However when its 0:00 I'd like the cell to be empty. Hope u can help out. Thanx Brian

Hello! I have a question about a calculation, hoping somebody can help me. So I need a formula to have one number subtracted by another number, then it has to be divided by another number but that number that its being divided by is minus 1. The number that is being divided by will always be...

Hi There, Thank you in advance for your help! I hope you can advise of VBA code for the following: I have a booking chart with dates going across columns. I would like to enter the the data into an activecell, and copy this across the dates based on a value as shown below: 1/1...

haha posted this one by accident.. editing in progress..

Dear Excel-wizards, Hopefully someone can help me with my VBA-programming problem. I want to show specific Rows in a sheet based on values filled in 1 cell. For example: When Cell A2 = "X" then show only the Rows that have "X" as value in Column A starting from Row 10 till Row 999. So only a...

Hi, Perhaps this has a simple explanation, I hope.... I'm trying to use the IF function to calculate some standard corrections. I'm using the following formula: =IF(AC9<1, Q9*AC9, Q9) Q9 = 53.00 AC9 = 0.74 The idea is that AC9 is a ratio, so if it is below 1 I want excel to...

Hi guys, hope somebody can help I need a formula to convert fabric weight to meters So lets say the gsm is 80gsm, the width is 154cm weight is for arguments sake 900g How would this be calculated into meters? Hope you guys can help Thanks

Hi All I am very new to coding in excel and have properly a easy questions that I hope one of you could help me with: I have created a drop down menu with option "Yes" and "No", the drop down menu is located in a cell I have called "hidemonths" The months I like to have the option to hide are...

Hello there, I wish to create a way of automatically entering a value of distance, depending on what the departure and arrival destination is. For example London(0miles) to Paris (1,000miles) automatically inserts '1,000' into the miles column. Hope this is possible for more than 1 set of...