range

  1. E

    Two Dates are within a month

    I need to identify whether two dates (Start and End) fall within any months from 01 April 2021 to 30 September 2022 Some of the End Dates are blank which shows that particular record is still active. Example Just a small look into the columns. Apologies, don't know how to increase the number...
  2. brendalpzm

    Change activeX combo box values depending on cell value

    Hello everyone~ I have a problem with a task that I'm not sure how to do it. I have an excel file where I make quotations and it brings a total quotation at the end. According to that quotation result I have an ActiveX combo box that should bring a specific range of values, for example...
  3. P

    I have a given range and trying to get the max value of corresponding column as per given range

    Im really not sure how to explain this but here goes, Starting from the right, as u can see each item has specific range of KP (from column K and L). We start with item 1 for example, which range from 0.211 to 0.216. Now i would like to match these range to the ones in column A. Once that...
  4. Chris_010101

    Formula Help

    Hello All, I need a formula that looks back 11 weeks from a given date and returns the Sunday at the beginning of that week. - Example, 27/10/2022. 11 weeks prior is 11/08/2022 and the Sunday beginning that week is 07/08/2022. The formula would return 07/08/2022. I also need one that looks...
  5. R

    Adding additional information to every nth row from start reference, copying same instance of rows

    I've got code here that will bring in information while looping through workbooks in a folder. It could be 5 workbooks or 50. Usually on the higher end. I'm bringing in 5 rows of information so every time i open a new workbook for information, i need it to go down to the 5th row and start again...
  6. R

    Formula to work out commission structure

    Hi, I require a formula to work out a sales commission structure as a lot of online templates seem to be different structures. In a nutshell, when looking at the picture, I will require 5 of the same formulas which I can replicate which need to go into the cells in yellow in G2, G3, G4, G5 &...
  7. C

    Excel to PDF - specific location saved by date

    Hi all Ive had a look through the discussion board and cant quite find what i was looking for, or the codes were very different. The idea is a macro button which saves to a specific location, saves as a PDF, saves name as todays date. Please find code below. Currently it is saving the PDF in...
  8. TheMacroNoob

    Two-way XLOOKUP() w/ Multiple Lookup Values (Range)

    Hello excel experts, I am using a two-way XLOOKUP() to grab a range of lookup values from a dynamic column lookup. The formula I am currently using is: =SUM(XLOOKUP($C$11:$C$43,INDIRECT("'"&G$10&"'!"&"$A:$A"),XLOOKUP($D11,INDIRECT("'"&G$10&"'!"&"$6:$6"),INDIRECT("'"&G$10&"'!"&"$1:$1048576"))))...
  9. K

    QUARTILE formula help needed

    Hello, I am struggling with quartile formula to calculate the selected value in another tab based on the description and grade. In the workbook I have one tab with all the data range based on description (i.e. Maths - A, B, C) and in another tab I need to calculate 3rd quartile for grade A, B...
  10. R

    Copy error - range is cutting and pasting to wrong sheet

    My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...
  11. M

    Count occurrence of individual date within dates in range

    I have a set of data in which two columns define a start date and end date - I'll call it my Census data. I have another dataset, call it my Day of Month data with one column that has individual dates of a month, i.e. 7/1/22, 7/2/22....7/31/22. In the range of start dates and end dates in my...
  12. D

    Set criteria to flexible range

    Hi all, In the code below I want to adjust the "criteria" line in such a way that it not refers to an array, but that it refers to a range in column A that is changing in size (sometimes it has more, sometimes it less lines) on a separate sheet (Sheet3) How do I make this adjustment? I know...
  13. B

    Copy a range of Rows and paste multiple time to another sheet

    Hello Experts, I've been trying to figure out how to do this macro. I have a sheet with A-AK in column to be copied multiple times to another sheet. I have seen and used the code found in this forum as well but with my requirements, I need some modification since the code copies the whole row...
  14. R

    How to get dynamic Dropdowns based on the header cell such that the dropdown options are from range, named header cell, in another Source Workbook?

    Hello everyone, I am struck with this problem since yesterday and have been unable to find any solution despite all the web searches. Please help me if it is indeed possible. To better explain the situation: We have multiple templates for different product types (400+). We share these files...
  15. T

    I have a question on how to VBA combination.

    Hi everyone, Just wondering if anyone can help me out here. When the value of column A is changed, I want to refresh the combination of columns b, c, and d. Also, if the cell is empty, I want it to be ignored. I've gotten help from the community, but it's not working. Sub...
  16. T

    I want to do a combination in the scope excluding empty cells in the VBA Range area.

    xDRg1, xDRg2, xDRg3 Ranges contain empty Cells. Can I do a combination other than this? Sub ListAllCombinations() 'Updateby Extendoffice Dim xDRg1, xDRg2, xDRg3 As Range Dim xRg As Range Dim xStr As String Dim xFN1, xFN2, xFN3 As Integer Dim xSV1, xSV2, xSV3 As String Set xDRg1 = Range("a2"...
  17. H

    How to have a calculation shift down 7 cells per 1 result cell.

    I am trying to do a summation of how many labs occur per week from a daily count on another sheet. However, I can not get the summation to shift down 7 days at a time. Is there a way to do this? Weekly summary: From the Daily Counts: I need It to sum a week at a time like this. Then , the...
  18. R

    Copy multiple columns to end of range without using .Copy or .Cut

    I'm trying to get better at this and in doing so, I've seen over and over again to stop using .Select and .Copy/.Cut to move things I know I can move my columns with copy and insert no issue, but I'd like to step into the next level. On one ws, i've got columns P to AB and need to move them to...
  19. N

    VBA typed range in a cell - Applying to a different worksheet

    Hello I have a weird thing going on with some practice code I'm trying. I am trying to create a code that copies the value of a cell, that has a range in it (@Rick Rothstein for helping with that). That works. I then want to use that value (the range) and select said range in a different...
  20. J

    How to merge multiple ranges into one array.

    Hy everyone, The below code works when the ranges are A5:J39, A44:J65 and A70:J89 Sub RangesToArray() Dim vRws As Variant, vData As Variant vRws = Application.Transpose(Split( _ Join(Application.Transpose(Evaluate("row(5:39)"))) & " " & _...

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