condition to a cell

Hello everyone! First off, I should start with a big, big thank you: I've spent a few days working on a template to create offers for my catering business, and this website has helped me SO MUCH! However, it seems that I can't make this one work, even by reading other posts: On the budget...

Hi, I'm a total novice with excel and have been playing around trying to build a tool to help with my PT business. Basically, I am building a BMI calculator in as part of it and want the cell below where the BMI result comes up as a number, (cell E5) to categorise the number based on my below...

I need to create a macro that will to convert formulas to values on the next row down after each time it is used. As an example Range ("B3:AD3") needs to be converted from formulas to values, but next time to needs to be B4:AD4. If it would make it easier, I do have other actions taking...

Hi: I have a table with 3 columns (NAME, ROOM, GRADE). I would like to be able to have a 4th column using the Rank function to have the NAMES ranked by GRADE but depending on the ROOM. So, in the 4th column, I should have 3 NAMES ranked as 1 if I have 3 ROOMS. The ROOMS are not numeric. They...

Hey guys and girls, I've learned lots from Mr Excel thus far, so thank you! I'm doing great building a VBA form to record in a worksheet, but I just hit a wall, so could really use some help! OK..here goes. I have a combobox and answers can only be Yes or No. If the answer is No, I need a new...

Hi I'm getting to grips with writing vba but I wondered if anyone could help me with a query. I have an Excel Workbook with 10 sheets within it. Each sheet is for a different company and each sheet has a list of suppliers within it. Basically I have suppliers listed as 1 2 and 3 (baed in...

In a sheet a user enters data in a range, say A1 to F5. In column A the user selects an item from a named list (via Data\Validation\List) with text values. Then, in columns B to F the user enters numbers. In any row he may enters 1,2,3,4,5 numbers or none. When he finishes he clicks a button...