merge

I have a table, listing about 500 people that have been issued between 1 and 12 roles each. Each row of the table has a role. So, if Mr Smith has 12 roles, he will appear on 12 rows. I want to do a mail merge which would send one email to each person that lists their roles. I can't work out how...

Hello guys, im setting up a tool and one of the steps is to merge some data together. It's a large document and my initial idea was to cycle back from last row, and check 2 cells, if they match between the 2 rows, a 3rd cell merges both row values and deletes the old one. <tbody> row nr /...

I have an excel sheet as given below. I want to name and address column in pivot table. If it is possible Sheet1<thead> A B C D E F G H I J </thead><tbody> 1 INVOIVCE NO INVOICE DATE CHELLAN NO PARTY NAME ADDRESS ITEM NAME ITEM CODE HSN QTY TYPE 2 5622218065 15/11/18 Samsung Mussaffa...

Hi, This is driving me insane.... I have this formula; =SUM(COUNTIFS('[19_20 Consultations Master.xlsx]Consultations'!$L:$L,"Accept",'[19_20 Consultations Master.xlsx]Consultations'!$AB:$AB,{"#N/A"})) Which is fine but as well as being an "Accept" in column L and an "#N/A" in column AB I...

I am trying to consolidate data from 26 workbook of same tabs and same columns into one workbook. All these workbooks contain data in same format and same tabs. I want all the tabs with the same name should merge data together and create one master workbook. Any thoughts on this.

I have an excel with diffent sheets having data, with different column names, i want to merge this into one? Please help me on this

Hi All First time trying to do this: I am trying to print labels from my Excel spreadsheet with Word using mail merge. It's a XLSM that I changed to XLSX. When Word tries to open the file, I get this message: This workbook contains unreadable content and cannot be opened. Any ideas? Thank you!

Hi there everyone! I was wondering if it is possible to merge cells through VBA code, cuz I've been trying to pull it off and it seems I'm getting nowhere, I probably need some extra help :laugh: So the thing is, I add two new rows at the same time with some data by clicking this button but I...

Hi I suspect there is a simple answer to this but I cannot find it! I have a sheet with a variable number of rows. I have totals at the bottom of columns J & K. I then have a combined total in column J - offset(0,2). I need to merge the cell in J with the adjacent cell in K. I have tried...

I have been compiling many many contact lists into a master excel sheet. Many customers were on multiple lists and are now on the master list multiple times (it is a large list) with many columns of categories and contact information. I need to combine duplicates --sometimes 2 duplicates of...

Hi all I would like to enter a value in a cell and have the 2 cells above and the 2 cells below all merge and increase the font size to 24 in bold. Example: A value is entered in A3. A1:A5 is merged. Font size increases to 24 in bold. Possible? Thank you! Russ

I watched a youtube video called Mail Merge Multiple Rows into One Document in Microsoft Word. I did every step he showed but my end result never works. I type out the code he says and it is suppose to turn into the end result but when I do finish merge it just say in code. What am I doing wrong.

I want to Merge and centre current row (row 2) with next blank row (row 3) if value is "Open". Similarly for other rows (6-7, 8-9, 10-11 etc.) Can you please provide any suitable VBA Program? <tbody> A B 1 Status remark 2 Open 3 4 Close 5 Close 6 Open 7 8 Open 9...

Hi Guys I need some help with a PQ Merge issue i have to tables that i merge with the simple idea via a SKU it collects Categories from another table. All SKU's are present and the Cats are also listed. THis worked but when i add new items the Categories are not being picked up. I have added...

Hello, I need a macro to merge as many cell in B as cells the same in a column A <tbody> A B 1 aaaaa merg 4 2 aaaaa merg 4 3 aaaaa merg 4 aaaaa merg 4 5 bb merge 2 6 bb merge 2 7 </tbody>

Ever had a table that has multiple rows of data associated with the same primary entry (say in column-1) and wanted to format your table so it only shows a single row heading entry for that value, rather than repeating it for each row? Of course you can merge your rows in a row to achieve this...

I am very new to excel . Please help :mad:

I would like to know in one needs to import each file one by one into separate sheets and then merge these. If not please advise how to go about importing several CSV files into one sheet

Hi I have found a way to merge all tables as one using G&T (Power Query) however I need to transpose each table ahead of merging as my data isn't structured correctly. Code: [View] =Excel.CurrentWorkbook() I have about 50 tabs which have a table on each where I need to run the same query and...

Hi I have found a way to merge all tables as one using G&T (Power Query) however I need to transpose each table ahead of merging as my data isn't structured correctly. =Excel.CurrentWorkbook() I have about 50 tabs which have a table on each where I need to run the same query and then append...