1. K

    Combine rows, add values in spec. column

    Hello, I have just started with VBA and I need your help. I've attached a picture and I will try to explain my problem. In "lastat"-sheet, I will add stock/pallets that I will move to another warehouse. With "Move"-button i move numbers to "Lagersaldo"-sheet. This warehouse will use...
  2. M

    Copy/paste values if the cell next to it is empty every month

    Is there a way i can copy paste specific rows to the excel ark. The things i need: - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book) - has to copy the value in the given row if the cell next to it is empty - the macro has to be applied from mappe1 (book) - next month the...
  3. J

    Show information Issue

    Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is: Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box The sheet name...
  4. G

    Command button to fill in cells in a column

    Hey good folk, I have a timesheet i get my engineering dept to fill in, we have a lot of customers who's name they have to input when working on a design. The "short" name our ERP system uses is noting like the actual customer name and my guys sometimes get confused. Anyway i have created an x...
  5. B

    Sum of vlookup in multiple rows with condition

    Hi, Let me try and explain what I need with a simplified example: I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality). I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...
  6. E

    Adding rows moves Pivot Table without data

    Never encountered this problem before. Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows... Thought something was amiss with the file itself so I created a new file and tried to...
  7. L

    Power Query - Append Grouped Rows based on specific columns AND row values

    Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost). Is it possible, via M code or otherwise, for me to group by...
  8. S

    Formula to return a sorted list, eliminating values already returned

    Hi all, I have a giant database of NBA players and their NBA 2k ratings, what I'm trying to do is automatically pull them into team lists: To get the starting 5 I use this formula in column C...
  9. S

    SQL Help - Duplicate IDs

    I have the 2 tables below: Table1 ID Start Date End Date ABC123 01/04/2020 13/09/2020 DEF456 03/01/2020 17/02/2020 ABC123 15/09/2020 30/09/2020 Table2 ID Start Date End Date ABC123 17/12/2019 12/07/2020 ABC123 13/07/2020 11/11/2020 DEF456 07/07/2020 09/09/2020 DEF456...
  10. M

    Extract and return a rows values and cells list which contains alphabetical texts

    Hi, Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8) desired results enclosed. Thanks for the help...
  11. M

    Filter/Transpose a multiple rows and multiple columns in a same row.

    Hi, Required a formula help for Filter/Transpose a multiple rows and multiple columns in a same row as per condition met with row headers . Row Headers that contain duplicate row headers and reorder all values or text values from multiple columns into one row. solution to be needed in Column...
  12. P

    INDEX MATCH -> multiple results from 2 columns

    Hello, I'm trying to get 2 multiple results from 2 different columns under 1 column and in order. Column E = Matching Apple in column A -> returning C value {=INDEX($C$1:$C$6,SMALL(IF(ISNUMBER(MATCH($A$1:$A$6,$E$1,0)),MATCH(ROW($A$1:$A$6),ROW($A$1:$A$6)),""),ROWS($A$1:A1)))} Column F =...
  13. W

    VBA code to shrink the rows by cumilating the data

    I have a excel sheet with around 5lakh rows and i want to reduce number of rows by cumilating same data. below is the sample data (Couldn't share original data due to privacy reasons). Data should be combined based on Columns B,D,E,G. If data present in B,D,E,F columns is same the code has to...
  14. Saher Naji

    Sorting Excel rows

    Hello, I'm trying to make the formula working on each 2 rows respectively, but I couldn't FX SWP product is displayed in 2 rows. I want to separate the two rows, and put one in the Short sheet and one in the Long sheet. Each FX SWP has the same Swap Number, with two Trade Number, one will have...
  15. H

    I need an update to this code (Which I copied from an answer on a post here) that could only delete rows that have :01 and :31.

    Sub Del_Non_00() Dim a, b Dim nc As Long, i As Long, k As Long nc = Cells.Find(What:="*", After:=Cells(1, 1), LookIn:=xlValues, SearchOrder:=xlByColumns, _ SearchDirection:=xlPrevious, SearchFormat:=False).Column + 1 a = Range("B1", Range("B" &...
  16. D

    Conditional formatting based on row data

    Hey all, I am not sure if this is even possible, but I figured I'd ask/give it a shot. In a spreadsheet I have a marker (denoted in cells with a * symbol). Is there a way (without using VBA) to use conditional formatting to adjust the colors of the cells around the marker? The following...
  17. M


    Hi everyone, Last time I reached out to you, I felt the love with so many responses so quickly. I am a teacher and I’m trying to look for ways to streamline my duties. I'm currently reviewing the courses I teach - focussing on equipment used, and duration for each module. I have been asked...
  18. A

    VBA rows selection leads to "selection wrong number of arguments or invalid property assignment"

    Hello! I'm trying to write a simple macro that will delete few rows, than sort by values from one of columns and than delete few rows below some value. I am using the strings of the code just strictly from "record macro" function. It does have codes like rows("1:6").Select or...
  19. B

    Place several groups of cells beneath each other

    Hi I have to make a summary of the different times it takes to add a certain product. Right now all the values I have are sorted by date and every date has all the steps. () I would like to put all the steps that are the same underneath each other so I can make a scatter plot. Is it possible...
  20. D

    Data Validation VBA Input Message

    Hello, I have a large batch of data. There are 5 different types of data. Every 5 rows, there is a new set of data. I am trying to implement Data Validation Input Messages so that when a user is on a certain cell, they will know what type of data is being referenced. Not sure if that makes...

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