solved

  1. H

    Conditional Formatting based on WHEN I enter data

    I have a workbook where I enter the same data each time I have a client show up for a session. I have to fill in the same 10 values based on what they say to me each time. I like to leave their values from the last session so I can remember what they were talking about. I am wondering if there...
  2. CsJHUN

    VBA userform progress bar for cycles (just sharing my code)

    Hi guys, i googled and forumed many solution for progressbars. Some are way above my head (with kernel inputs, hardware keys, so on), so i try to made one for myself which easily readable and understandable. I made a simple userform with 3 label. First is just for sub title, third is for text...
  3. M

    Filling an array with sheet names - VBA

    Greetings, I need to print a set of user-defined sheets form a workbook and I want them in ONE print job, not individual print jobs. Reason being, I want to create a PDF file with 1-10 pages, not ten pdf files. I can gather the sheet names the user chooses and put them in a place in the...
  4. P

    VBA Macro Select Worksheet If Name Contains String

    Complete macro noob and not sure what to do. I have borrowed a macro from this forum to select a tab based on the worksheet name Sub Macro1() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name Like "* Apple" Then ws.Select Exit For End If Next ws End...
  5. N

    Lookup then RAG status

    Hi all, Need some formula help (i think) I need a RAG dashboard lookup formula, its based on a list of text. Ive tried a few things including custom number & index match but it doesnt seem to work. Any idea on how i can do this? I have this list of data: Name Testing Approvals Reviews...
  6. T

    Web Scraping with Excel VBA

    Hello, I have some script below in which I am trying to extract the information listed in the red box into an Excel file using VBA. Ideally, I would really love to get everything under the <div class="kioskDockDoor blueBg" line but I'll take any help I can get. I've tried multiple variations of...
  7. E

    Exporting to CSV, messed up date format.

    Using this: Private Sub Create_CSV() Dim content As String Dim Rng As Range Set Rng = Range("A12:AS30") Dim Path As String Dim FileName1 As String Dim FileName2 As String Dim FileName3 As String Dim sWB As Workbook, _ sWS As Worksheet Dim dWB As Workbook, _ dWS As...
  8. A

    AutoFill in Selection Range Method

    Sub demo() Dim myRange As Range Set myRange = Selection myRange.Cells(1, 10).Select ActiveCell.FormulaR1C1 = "=test" & "(RC[-9])" Selection.AutoFill Destination:=Range("RC[-9]:RC" & Range("Selection" & Rows.count).End(xlUp).Row), Type:=xlFillDefault End Sub A B C D E F G H I J Text1...
  9. G

    FormulaLocal vs Formula2Local issue

    Hi folks! I'm just trying to write a formula in a cell. if I use Formula2Local I got a '1004' Runtime error. Worksheets("SK").Cells(ACT_row, Col_VAL).Formula2Local = Aggr_costi if I use FormulaLocal everything run smoothly Worksheets("SK").Cells(ACT_row, Col_VAL).FormulaLocal = Aggr_costi The...
  10. K

    Turning a Table into a sorted Column

    Hi. I'm working on a vacation calendar for a group of teams. I have the data in a table like this: group name location TeamA Person1 S TeamA Person2 R TeamA Person3 P TeamA Person4 S TeamB Person5 R TeamB Person6 P TeamB Person7 S TeamB Person8 R TeamB Person9 P TeamB...
  11. C

    VBA: Search for Text strings and return value from table

    Hi all, Long time lurker, first time poster - let me thank you all for years of troubleshooting and learning with pro's how to be a bit better in Excel. My question is around VBA - not very well versed in it - and will try to explain as best as I can. I have a list of countries with a score...
  12. J

    Formula: Countifs

    Hi guys I'm trying to put together a countifs statement but am getting a little stuck. I want the formula to calculate how many blanks are in the corresponding C column, if the value in the B column is 5. I managed the first condition (to count how many 5s there are in B): =COUNTIF(B2:B10,5)...
  13. R

    dependent cells to follow decimal formatting of parent cell

    Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...
  14. H

    Help 2 this Formula (if and) or

    Hey Group I need some Help to this formula =IF(And(D9=1;L11=1);D12) That Part Works Fine i now need a "Or function after that Working formula so it might look like that perhaps =IF(And(D9=1;L11=1);D12)or If(And(D9=1;L11=2);D11) i have try that but it wont Work and not for any thing i...
  15. J

    M code for same date last year

    Hi. I have a problem that is driving me nuts. Am fairly new to M code but thought trial and error would have solved my problem by now. Upside is I have learned a lot on the way even if I still haven't solved my problem. I have a (text) column called EntryDate with the date of all orders...
  16. M

    Calculate group average based on multi-tab constituent values

    I'm trying to calculate a simple AVERAGE based on two source tabs 'Category' and 'Score'. Stipulations: 1) No helper columns on the source tabs; data from source tabs are exports from other systems that must remain untouched 2) Average scores on 'Result' tab should be calculated using a formula...
  17. R

    VBA code for copy/paste a variable amount of rows and adding a certain value in one specific column

    Hi there, I´m new in the VBA world and I´m trying to learn how to use it in an efficient way and at the same time develop a feature in my spreadsheet, see bullet 4 below: #1 Copy an activated row, insert a new row below and paste the formula in column(not formula) there (Solved) #2 Highlight...
  18. J

    Can I run the filter for Column A off the drop down menu in Cell D9?

    Any Help would be appreciated. I had one issue solved on here today if I can get this one I would be ecstatic! Thank you! - Jessy
  19. D

    SUMIFS with multiple possibilities for 2 criterias

    SUMIFS with multiple possibilities for one criteria, can be solved using: =SUMPRODUCT(SUMIFS(G10:G100,A10:A100,A5,B10:B100,B5,C10:C100,C3:C6)) According to: https://www.mrexcel.com/board/index.php?threads/821600/ But If I need to apply SUMIFS with multiple possibilities for 2 criterias...
  20. R

    Userform help

    This is my first attempt at building a Userform. It was actually going well and everything was working until I realized that one of my boxes was not posting a result. On the form I have a series of questions with Points awarded based on the answer. For example: It the answer to question 1 is...

Watch MrExcel Video

This Week's Hot Topics

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
Top