depending

  1. A

    Distributing specific information from one sheet onto 4 more sheets depending on values

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

    Macro to send email based on ComboBox

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

    Nested Excel Function

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

    Autofilter table depending on the date value from different sheet MACRO VBA

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

    VBA subtotal depending on indent

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

    Clearing empties from a 2d array

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

    formula needed!

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

    IF conditional formula

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

    Dynamic Lookup Depending on Criteria

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

    Putting dates on sequential results

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

    Grouping a pivot table by variable groups

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

    Isssue with resizing the images - INDIRECT FUNCTION

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

    Can you use a filter in an IF()

    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?
  14. D

    VBA code to specify sheets depending on date

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

    Hide/Unhide Sheets Value on other cell through formula

    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 =...
  16. M

    Extract data from Columns and rows

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

    save a file depending on the date value on cell

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

    Choosing the best cell

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

    Assigning a value to a msforms.frame object.

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

    Index Match then average if

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top