1. 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...
  2. G

    Merge multiple rows based on duplicate cell

    I have a list of movies that have won or been nominated for one or more awards in various years. I want all award information for one title to appear on one line. Is there a way to do that? Each award has three columns of information: award name, whether the film was nominated or won, and year...
  3. G

    Consolidate/merge data in duplicate rows separated by delimiter

    Hi Experts, Project: I am working on Power BI project where I am fetching data from many JIRA projects. The only problem here is one field which is not used in a harmonized way for across all JIRA projects and i.e. Release Information. For all JIRA projects in my report, I derived that...
  4. W

    Combining Columns with Dynamic Values

    Dear Pros, Please how can I use formula to create COLUMN C from A and B?
  5. S

    Merging workbooks

    I'm trying to create a macro that will create a new workbook and then copy all sheet(1)'s from all other open workbooks to it except for the workbook where I have all my macros stored. So far, I'm able to create the new workbook and save over it if needed (and it will be). But it's not copying...
  6. F

    Merge data and delete duplicates VBA

    Hi all, I am trying to build a tool in excel that can simulate and give an overview of packing plans, but i am having trouble getting a "timeline" to work. The sheets with the timeline are imported based on choice and will change in how many are imported. It needs to be VBA, the persons who...
  7. L

    Conditional Merge

    Good evening everyone, I had a question ... btw, excuse my bad english: I have a couple of tables, CONTRIBUTION and BILLING, which have an "ID" field with which I relate them (the relationship between the tables is * (CONTRIBUTION) -> 1 (BILLING)), as well as a CONSUMPTION (numeric) field , a...
  8. A

    Loop to merge cells does not work on last few rows

    Hi all! Im having some issues with my code below. It works fine on majority of rows, but towards the end, it's having some issues. What my code does is this: - if values of cells (i,j) and cells (i+r,j), basically 1 cell and the cell below it are the same, then they merge and other columns...
  9. L

    in PQ can we merge multi sheets in Multi Workbook at same time

    Hi all i have 5 files for 5 regions each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis ) i merged it by my PQ File file then i use PQ also to Merge it all in one file that is mean i use PQ 5 times for 5 files then i use it again to merge it all in one file can...
  10. S

    Mail merge multiple data rows to one email address

    <tbody> Email Data 1 2 A B </tbody> Hi guys is there a way that I can mail merge 1 email with several rows of data, instead on several emails with 1 row of data? desired result - Ste recieves 1 email which states...
  11. A

    Mail merge with excel

    I use excel spreadsheets (xls, DDE) as the database for my mail merge in word. After the upgrade to Word 2016, the excel open a new file (Book2) automatically when I open the word file. The main problem is that when the new excel file (Book 2) was opened, all the previous entered data was not...
  12. B

    What is early binding and late binding

    Hi I am new to these concepts. Not requesting for exact answers. You may also help me with useful links for these two. I know Google will help, but trying to seek help from experts here. Also, I have another question here. Not sure if I can merge it here only. How does early binding or late...
  13. A

    Code merge data of multiple sheets in one sheet

    hello i need help to find code merge data from 3 sheets in one sheet i have 3 sheets every sheet contains data in table with headers begins from b4: h10 i would code to merge data from theses sheets to sheet4 also when happens every change automatically changes in sheet4 i...
  14. E

    Using VBA, easy way to copy data from a few tabs into 1

    Hi all, So I have a few tabs with changing names, that sometimes are there and others there aren't. For example. I will always have a "Sheet1" then after that they may not be there, "Sheet1 (2)", "Sheet1 (3)", etc. I need help writing a macro that will copy the data from "Sheet1" into Cell A1...
  15. P

    Merge Empty Cells with a cell with a date

    I am trying to merge 5 columns together where only one column will have a date in (dd-mm-yyy) and the other 4 will be blank. The column that contains the date is random and changes as you go down the spreadsheet. Can anyone shine a light on a formula that KEEPS FORMATTING of the date when the...
  16. A

    Organizing Columns w/ First and Last Names

    Hi, I'm working on a stats project and need some help. I've got my two columns, one for first names and the other for last names, and I'm trying to figure out how to merge them so they read in one cell as the full name and then alphabetize them by last name; if it is possible. I've gone as...
  17. H

    Call Word document (with mergefields ready) and MailMerge it from Excel (all hosted on Sharepoint)

    I have to setup a series of mail merged forms for my school to invite guest speakers to our classrooms. For that, I have setup a table called Guest_Speaker_MM. I've already created all the merge fields and tested them using manual mail merge and they worked fine. However, when these files...
  18. H

    Merge two ranges together and wrap them into each other

    Hi all, I want to merge two ranges together. The first range is equal to Sheets("1").Range("B1:AA100") the second range is equal to Sheets("2").Range("B1:AA100") I am familiar with the UNION-function, but I want to merge them differently. Basically, I want to merge them column for column...
  19. D

    Getting Power Query to add new values to the bottom

    Hi All, I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel. so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so...
  20. D

    merge sheet vba help

    Hello everyone. Is there a way to tweak the below vba so it only merges 2 sheets from my workbook vs ALL the sheets in the workbook? For instance i need it to merge sheet name "hello" and sheet name "bye" THanks!! Sub merge() Dim wrk As Workbook Dim sht As Worksheet Dim trg As...

Some videos you may like

This Week's Hot Topics