depending

Hi I have a cell that reads the student's average from another cell. I use =$B$70 and the average from the B70 cell appears here. Is there a way to have TEXT and this dynamic average appear in the same cell so the student name and THEIR average (which changes depending on how B70 changes)...

hi guys i have two tables in different sheet on sheet 1 is where i want to put the total of the amount that i input on table 2 on sheet 2 depending on name on column B and the header of the table, like the sample table below <colgroup><col style="width...

Hey, I am going to record my first macro but I am a little confused as my example isn't the easiest. I basically have a table on a second tab within the sheet which I will be using to pull data from however the table is an order export list so it will vary in size each time depending on how...

Hello, I'm having problems getting a macro to run from a button in one of my workbooks. Sub HideAllSheets() Application.ScreenUpdating = False 'hide all sheets with no data Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets If ws.Name Like "Data #########" And...

I am making a macro that will send out an email to different people depending on the value of a filter in cell C1. I have managed to compile the macro to work depending on a cell value (cell C2) however as the cell value does not change when the filter is applied I need to select the different...

Hallo MrExcel I have for some time tried to find a solution for this, both on google and on the forum. Unfortunately i have been unsuccessful, therefor I'm now turning to you in the hopes that you might be able to help me. I'm trying to get excel sheet #1 to copy data from several rows to...

Hi I am trying to put some names into excel to create a histogram. I have everything inputted but I want the colours in the cells to change depending on the job role, i have a couple of rules but cannot seem to get the rule to do a formula that makes the colour change depending on the job role...

Hi All, Hope you could help me with yet another problem. So I need to create a usage statistics report. As part of the report, I want to create a monthly trends chart. I have figured out a way to do this without any problems. The problem I cannot figure out is how to tell VBA to not create...

Hoping someone can help me out here. I have a workbook with multiple worksheets and would like the worksheet TAB COLOR to be conditionally formatted due to the contents of the cells in a particular column. (The particular column may be different depending on the worksheet). For example: Sheet...

hi guys, what i want to do is to change the color of a specific cells range depending on the text content on the cell column called ubi, so far this is what i have written, i dont know VBA though. im missing how to write the range on the specifi cells I guess. Function apa() If (cell.Value =...

Hi all, I am trying to calculate shift rates depending on times. I have the following shift rates, but I cannot seem to get the results returned I'm looking for due to the times of some shifts going past midnight. As an example a shift might be 15:30 - 01:30. <colgroup><col width="145"...

is this possible is F11 is 2 it will set box 1 and box 2 and box 4 a print area, if F11 is 3 it will make box 1 box 2 box 3 box 4 a print area, if f11 is 1 it will make box 1 and box 4 only the prin area <colgroup><col style="width...

Dear All, I've created a sample file that is similar to what I'm trying to do. Here is the file: http://jmp.sh/0N6bvAD Thank you if you have time to give it a look. My goal is to create checkboxes (or combo) that filter the results depending on the values of the colums. If possible I'd like to...

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...

I'm trying to sum up columns of data, but the numbers of rows will be different each depending on the inputs that the user puts in. Is there a way to have a adjustable R1C1 formula?

Hello, I'm trying to get cell N5 to return the monthly value from row 5 depending on the current month.

When I use the following, I place the formula into the Spreadsheet and get the resulting row number. Range(emailColumn & FirstRow & ":" & emailColumn & LastRow).Formula = "=MATCH(B2,'RosterFileName'!FullName,1)+3" When I try this function in VBA I get different errors; syntax, compile error...

Hi If I have $0.194 how do I get 0.195? Or how do I get the third decimal spot to either be a 0 or 5 depending which is closer?

Firstly Hi. My first post so hopefully its not me being a numpty. I have some data in a table that depending on the value contained in a certain cell i want it to deselect the value in the cell so the rest off the macro can just delete the table contents that do not meet the requirements...

Hi, I have an excel formula that I cannot get to work for love nor money. I am trying to SUM a number, depending on whether a date falls within a certain range? I am using the following: =SUMIFS($E$6,M5,">="&$F$6,M5,"=<"&$G$6) Where: E6 = £50,000 M5 = Jul-18 F6 = Jan-18 G6 = Dec-18 Where am...