Help me merge these please?
Contact Tag 1
Example: (123) 456-7890
(Only if Email column is blank)
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...
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.
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.
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
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...
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.
Output required in one cell = A,B,C,D
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...
Would anyone out there be so kind as to tell me how to merge uneven names?
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:
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.
Dim x As Integer
Dim y As Integer
x = InputBox("first col#")
y = InputBox("second col#")
I have several hundred .xlsx files with data I want merged into one file.
* Only .xlsx files
* 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
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...
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...
I am merging data using the Kutools Add-in. I have around 200,000 rows which have to be merged to some smaller number of rows. How do I know if excel is still merging or it just froze?
I hit CTRL+ALT+DELETE and hit Start Task Manager. Then, under Applications I have the following...