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

    Combine overlapping dates and find non-overlaps for multiple unique ID's

    I have a very large spreadsheet with headers (180k+ rows) with unique ID's in A, start date in B, and end date in C. There are multiple rows per ID and the start and end dates overlap in a messy way. I need to find any gaps in the date ranges for each ID. I've written a few different formulas...
  3. O

    Multiple Private Sub Worksheet_Change

    Hello, I need help with combining these two codes into the Worksheet_Change sub, I can get them to work on their own but can't combine them properly. In the first sub I am ensuring users enter a date in the date field when entering data in other columns in the row: If Target.Cells.Count > 1...
  4. 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...
  5. N

    Combining multiple Password Protected workbooks into a single workbook

    Hi All, I will be having around 85-90 password protected workbooks. They all will have different passwords. I shall collate them in 1 folder. I will have a list of the workbooks name and their passwords (preferably in sheet2). I need a macro or code which will open the workbook with the...
  6. M

    Macro to combine data sets with a ratio

    Hello, I am looking to create a macro where i can combine two sets of data based on a ratio. I am pretty good with macro's but i cant seem to work this one out. I want to start with an easy ratio of 1:1, so i have two data sets 'MLA' and 'PLA' and i want to combime them on a 3rd tab in the...
  7. N

    How do I merge tables with common ID values without having value repeat ?

    Hi, I have three tables showing Plant, Material and Labour quantities from each of my crews on site, The tables are linked by unique identifiers or "Shift Report Numbers", however, multiple items assigned to each unique identifier. For example: Shift Report Number Date Job Code Labour...
  8. M

    Required a formula to return combined a list, common values in a both list, values not included in each other List.

    Hi, Required a formula help for do a different types of workouts as based on data (Work items list-1 & 2) contains in Column A to C, for there required details as follows. In a Column E, Cell number E4 to be return a Combined work items lists (merged list) of both lists into one list, Sort A...
  9. G

    VBA to collect data from different files to one file on different tabs(worksheets)

    Hi All, I am trying to get a vba code to copy information from different files to one destination file but on different worksheets on the destination file. The destination file is called "Master data file ". The master file has worksheets named ""Sheet1","Project1" , "Project2"...
  10. R

    *URGENT* Merge Multiple Workbook into One and then combine

    Hello Everyone I have two workbook in one path and both have same headers. I have code to merge both the workbook into one but then i need to combine them into one worksheet. like copy data from one sheet to paste on another sheet last filed row Sub GetSheets() Dim Path as Integer Path =...
  11. C

    Combine lists with similar headers

    I have a spreadsheet with hundreds of lists that each have a header and vary in length. The headers all follow a similar format (ABCD 123AB) and I want all columns for which the headers share the first 8 characters (including the space) to be combined into a single column with the header being...
  12. T

    Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another)

    Hello all experts : ) I would like to Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another) Below are some screenshots from the files I would like to merge, there are 130 files. Let's start with smaller sample, I would like to combine file 117 and 22...
  13. D

    Data consolidation with permanent cell and IF statement

    Hello, im having trouble with coming up with a formula for the following case: We have sheet with data about different products: Product Quantity Location Product 1 5 1-1-1 Product 1 10 1-1-1 Product 1 5 1-1-2 Product 2 10 1-1-2 Product 3 5 1-1-2 Product 3 10 1-1-3 Our...
  14. M

    Combine data from different cells to one cell

    Hi, I am trying to figure out how I can get from table one to table two with formulas or some easy VBA. As you can see I want to make one row for John and one for Jenny, instead for two as it is now. The date should also be combined so that the first start date and the last end date shows. E.g...
  15. C

    Combine worksheets from multiple workbooks

    Good day experts, I'm attempting to combine one sheet out of multiple workbooks into the sheet where my module is located. The workbooks are located in the same file on the network, but I don't want all of them. The sheet name is the same in each workbook. I found a code that works well at...
  16. B

    Power Query - Combine, transform and track data

    Hello All, As a reasonably seasoned excel user, im embarking on learning power query to try to achieve something which could quite well be impossible :) So hoping I can get some clarification from the real experts! Situation: I have a CSV file provided to me every day detailing a list of...
  17. R

    Combine mutliple file in one PDF through VBA

    Hi All, I want to combine multiple files into one PDF. I found one code which is working fine if my all files in PDF format. Here my concern is, I have PNG files as well and the code is not able to combine PNG file however if i am combining manually then it combines all the PDF and PNG files...
  18. H

    Combining 3 x INDEX MATCH

    Hi All, I have a column with INDEX/MATCH formula, but the match value could come from 1 of 3 possible columns. Could you help me combine the below into one formula please? =IFERROR(INDEX(admin!$C$4:$C$100,MATCH(C4,admin!$B$4:$B$100,0)),"0")...
  19. J

    Combine a single list of unique parts with a list of 35 components that belong to each part

    I have list of unique VINS. I also have a list of 35 parts that belong to each VIN. I need to combine these list so that i have A VIN, then 35 parts, then ANOTHER VIN with the same 35 parts, then a 3rd VIN, etc. Seems like it should be easy . . . but stuck. A macro would be nice . . . but...
  20. G

    Combine Nested Funtions

    Need help combing these function into a single cell This formula recalculates the date based off a value in column P =IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90)) This formula determines the amount of days between today and the new date =ABS(AN16-TODAY()) This formula enters...

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