depending

Hello everyone, I've been doing some research lately on this forums threads seeing if I can find a solution that is similar to the situation I'm in, but have found that while some come close, they weren't necessarily the fix I was looking for. I have a workbook where I'm forced to distribute...

Would it be possible to have your help to create a macro that allows to send an email notification based on the assigned name on ComboBox3 where I can modify the subject and automatically attached a pdf file that it is previously created. The path of the pdf file changes depending on the entry...

My formula is as follows: =IF(OR(P17="A - Svcbl(w/o Qual)",P17=""),(AM17+365),(AM17+10)) and I want to add the below to the formula. =IF(TODAY()-RC[-2]>=91,""Over or equalto 91 days"",""Less than 91 days"") How do I nest these 2 formulas together Bottom line.... I have a value in column...

Hi sir as the title say, i want to filter a table depending on the value form different sheet i have 2 sheets Sheet 1 is where the cell is located with a date (Example cell is B1) on Sheet 2 i have a table with a column "DATE", i want to filter the column DATE, depending on the given date...

Hi, I have a table with text and numbers that i got from MSProject, for example: <tbody> <colgroup><col span="2"></colgroup><tbody> A 36 A.1 10 A.2 12 A.3 14 B 61 B.1 38 B.1.1 15 B.1.2 11 B.1.3 12 B.2 11 B.3 12 </tbody> </tbody> My goal is to run a...

Hey guys, i have an array, once creating it i make it 2d: ReDim allPksWithEmpty(1 To lastRow, 1 To 2) Since I'm not able to set the 1st dimension anymore, i cap it out at maximum rows in sheet. Of course i only pick up a little data depending on some ifs, thus i end up with a big array...

look for a formula for: Value of each cell in column C is either 0, 1, 2, 3, 4 or 5 depending on the vale of the column to it's left 0 = <20 1 = 20-40 2 = 41-82 3 = 83-144 4 = 145-207 5 = >207

Hi I'm sure this is simple but I need a formula in a column that differs depending on the value in another column. This is how I would define it: IF A1="APPLES" THEN formula = G1-K1 ELSEIF A1="PEARS" THEN formula = K1-G1 It simply swaps the column values around in the actual formula to be...

Hello, I hope someone can help, as I have brain freeze over this. I have a worksheet with a series of payout curves: https://1drv.ms/u/s!AiTfuC9hs0NdnnjZczIuwXQxVYDA And a second with a summary of sales by person: https://1drv.ms/u/s!AiTfuC9hs0NdnnmeguWNe1F12q0_ (Sorry, I can't seem to put...

PLEAAAASSEEE HELP ME!!! I am trying to create a route from an excel sheet where it will be placed to a site program then it will auto generate depending on the data provided. I have used basic excel methods but to no success. I need to have the properties scheduled on a monthly basis depending...

Hi, I am trying to come up with VBA code for a pivot table where by the row groupings change depending on the numbers in specific cells. For more context, I have a 70,000 row list of consumption amounts which i would like to be able to split depending on the way i have split some tables in a...

Hi, In my tool I had to implement an idirect function with linked objects in order to get the image to be called depending on the cell value. It s dynamically changing depending on the product configuration. In order to do that I’ve created a library/master table with tye images exactly fitting...

Can you use a selection in a filter for a pivot table ie ALL and use an if() to do a calculation depending on filter value?

I have a spreadsheet that transfers rows from a excel table to sheets depending on the date. The reporting month of where I work goes from the 26th of the previous month to the 25th of the current month. I had it all working when the table in my home sheet had one row but now it has multiple...

Hello, I'm stuck so hopefully somebody can help me with this. I'm trying to Hide or Unhide some sheets depending on the value of another cell. I have this: Private Sub Worksheet_Change(ByVal Target As Range) If [E3] = "YES" Then Sheets("Sheet2").Visible = True Else Sheets("Sheet2").Visible =...

Hi everyone and thanks for reading this message I hope it makes sense. I have this exercise I found on the internet in which i need to return the price of the breakfast in a chart depending on the room type and Hotel Category. Basically I need to multiply the "Breakfast price" with the...

hello guys is i need a code that will safe a workbook on different location and will set the file name depending on the value on the cell, the format of the cell is in date, thanks

Hi This post has two requests I have the data shown below: <tbody> A B C D E F 1 Target 1 Target 2 Value of Target 1 Value of Target 2 Best Target Best Value 2 5 4 -0.78 2.22 </tbody> I would like to research two possible options as I am not sure which will suit my purpose best...

Hi everyone I have several frames within a form I'd like change the attributes of depending on the click of a button so, I have declared an object in module one Public frametochange As MSForms.Frame in Form1, I have many frames I'd like to change if a button is clicked. in the button...

Hi and thanks in advance in case anyone can help me find a solution. I am trying to combine an index match with an average if. Attached is a screenshot, and the green cells are supposed to calculate the average P/E ratios depending on the timeframe in B4-D4 (1yr-5yr). So for the 5yr (green cell...