merging

I want to merge files "Data" which are in "select input folder"button and "select output folder"button into one file Both the files "Data" Should Merge When I click Execute button Is there any macro to dd?please help me out

Hello, Let me start by saying I'm aware that merging two cells A1 and A2 should remove the value from A2 but I was given a workbook with merged cells where the second cell's value was not removed. However, I am unable to reproduce this when attempting to change the values In the example, I...

Help me merge these please? Template: First Name Last Name Email* Mobile Phone* Country Block Communication Employee Email Contact Tag 1 Example: John Example: Doe Required Example: johndoe@yahoo.com Required Example: (123) 456-7890 (Only if Email column is blank) Example: US (Select from...

Hello All - I have been sent a worksheet with dates from a user in Australia. The date format is: 17/06/2016, so Day, Month, Year. And to be more specific, what I've been sent is: 17/06/2016 18:53, so D, M, Year and a time stamp. There are other dates that I need to merge and sort with these...

How does one merge several work books each has 1-3 sheets into 1 large workbook while keeping the formating and VBA in tact?

I have a workbook that has 5 similar Sheets worth of data in columns A:U. Is there a way to create one giant database out of the 5 using VBA? Little out of my element and macro recording ability. Thank you

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

Hi there, I have 3 columns of data in the following format: 1234 99 1234567 and I want to get it all into one column but in 2 different formats as such: 1234991234567 and 1234-99-1234567. Would be most grateful for any help

Hello there! Some time ago I found 2 VBA code blocks on the internet that allow me to do the following: * automatically merge all cells with the same value in the active worksheet * automatically unmerge all merged cells in the active worksheet without data loss (the original value of the merge...

Hi, I have entries in columns A - x . I want to have all these entries in one cell with a comma(,) after each of the entry in the column cells. Ex:- A B C D Output required in one cell = A,B,C,D Please help. Regards, Nik

Good morning, I have excel files in directories that I need to rename based on the value in specific cells in each worksheet and need help with a macro code to achieve this. I would like the macro to loop through the folders and rename each file based on the value it finds in the indicated...

Greetings! Would anyone out there be so kind as to tell me how to merge uneven names? For example: File1 has 3000 rows or names. File2 has 4000 rows of names. Customer wants the last name and all its' records to merge to one file but there's an uneven amount of names like this: Attached are...

Hello, I have two tables that are maintained separately, but share common elements. Based on those common elements, I would like to merge the tables and extend them into a full data list. The first table has headings across the top (let's call them location groups) that need to be looked up in...

Hi the code below does not give me an error message but does not do the job either? Any help would be appreciated. Sub col_merge() Dim x As Integer Dim y As Integer x = InputBox("first col#") y = InputBox("second col#") Workbooks(1).Worksheets(1).Columns("x:y").Merge End Sub

Hi, I have several hundred .xlsx files with data I want merged into one file. * Only .xlsx files * Sheets("Sheet1") * Data is in A:F starting at row 2 Best way to approach this? Files are all under 100kb and contain roughly 2000 rows in each Appreciate any help

Hello, I would like to have makro which will be merging cells based on values on next column plus making sum of this cells in column C So I have: blank A 5 blank B 4 blank C 6 blank D 7 blank E 9 blank F 11 So excel merge cells where blanks are for A,B,C plus...

Yes, I'm aware that merging cells in VBA is not recommended and often a nightmare, however it's a necessity for the workbook I'm working on. Please feel free to slap my hand for merging though haha. I'm looking to merge two cells in a column. It needs to be activecell based and not based on...

Hello, if I have a row in which cells A-D, are merged, then E-G, H-M, etc. is there any easy way to copy that row so that all rows individually have those same cells merged within them? Thanks!

I am merging left table to right table and removing duplicate. My problem for data like 00001 result became 1 only. I already make cells as "Text" and data stays 00001 but during merging tables it is still shows 1 only and the results table also shows 1.Is there any way thay I could make the...

Is there a way to automatically align left and align top cells when merging cells? Its annoying when it defaults to center and bottom.