merge

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

Hello, I am working in a mail merge document, and I need the output to look something like this: Vacation: Life Insurance: Disability: etc. However, the issue is that sometimes the fields are blank, and if they're blank it messes up the spacing. I want the document to ignore any blanks...

Hello Experts, Following is actual data and the common column in both sheets is "Style No.". The two sheets have thousands of records. Lets say first sheet is with prices and order quantity and the second sheet is with actual shipped quantity. TABLE 1 WITH PRICES...

I have an spreadsheet that summarizes various documents and includes the file path to each document. I have created a mail merge that creates a document summary page for each document based on the data in the spreadsheet. What I would like to do next is generate a single PDF that places the...

I have a file consisting of over 17 thousand rows of information. The file lists out employee data in columns A-H. This portion of the file is ok. However in column I a list of questions are referenced vertically. Each question appears in a separate row. The employee's answer to the question is...

I have two different workbooks that has identical table headers. It's used for timesheet registration but I have 2 computers set up so people don't have to be in line. I've created a connection between the 2 workbooks so I can pull the tables to a "Master" workbook. I've manged to get the two...

Hi, Is there a way that as a result of an IF statement that 3 cells become merged? IE: IF cell 1A> 2 merge cells 2A, 2B, 2C Else Nil Thanks Aaron

Hey folks, Suppose I create two queries for the two tables in my spreadsheet https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI Is it possible to somehow merge them as per my example?

hey guys, basically the title said it all. I have one excel file, that contains the sum of lots of files, they were all the same format, rows and columns, but with different values,it's cool that with a macro I have been able to put them all in the same sheet, but I don't know where can I go...

Hi all, I already have a word document with mail merge linked to the excel spreadsheet. Now I created a button in this spreadsheet and I want to be able to click and open the word document. I have tried several times, but it will only open the word document with no mail merge. I tried all the...

Failing at every turn to get the correct formula. IF cell P1 contains the word Delivery concatenate 3 cells together. This I have been able to do. but adding If Cell P1 is equal to Pickup then merge these 3 cells. When it says Delivery im good but otherwise I will get a False return instead...

Hi, Thanks in advance My Query is My hosting account has a limit of sending only 200 emails/hour - 20 per minute. I broke my list down into sets of 200 to send out every hour. However, when using mail merge I can't find a way to control how many of these are sent per minute. Is there any way...

Hi there Excel-people :biggrin: For part of my job I have to take data from one Excel list and make it in to separate Excelforms. It takes up so much time, which I don't have. So I was thinking... Is there a way to merge the Exceldatafile in to separate Excelforms? (We use the later as a sort...

Hi All, When doing Mail Merge, is it possible to send individual customer with individual different excel worksheet in each email as an attachment? Cheers, Peter

Hello! Is there a way to merge vertically cells in a range? (i.e. merge together the cells of all the select rows within the same column) Merging the left column cells and dragging the formatting to the right does not work well, because it does not keep only the top cell value, but it retains...

Hi All, i am not very good with macro and although i understand a bit i am not good at amending them and fit my my requirement. I have read few thread on looping and if statement but i am no tbeen able to create a macro that will serve my purpose. Here I am asking for your help In my table I...

Dear all, I have a problem which I cannot solve (up till now) I have two files (A and B). Both files have macro's which are activated by clicking knobs in some sheets in file A and file B. When I merge these two files, I copy all sheets of file A into file B. Next I import all modules of file...

I have two named Tables detailing price proposals from mfrs on different dates I want to merge these into a single table detailing the minimum cost and associated detail per Item <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Item Mfr MPN Cost 10001...

I have a problem for some month now. I am not sure wether this can be solved. I have 2 files which both have macro's, knobs to activate these macro's and pictures which are manipulated by macro's Now I want to merge these two files including the micro features. Up to now I have copied all...

Hello! I have merged cells A1-A3 and I want to drag this and merge B1-B3, C1-C3 etc. However, dragging the + sign copies also the formatting, not only the merging. Is there a solution? Thanks!