merging

Hi I need help on coding of prefix on invoice numbering as well as merging cells horizontally and vertically, Thanking you in anticipation Sincerely Yours Mfana

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

Hi, I have the code below which creates a file from every worksheet in my workbook. It works fine however it doesn't preserve any cell merging when it creates the new files - the merging is lost in the new files. Is there some code that I can add into this routine so any cell merging is...

Hi all, I have a report I receive on a weekly basis where it lists customers performance/data over 271 columns and over 1000s of rows. In this data there are many lines which are duplicated for customers as they have more than one account number. Is there a way of merging/summing this data...

Hi guys, I need simple vba for merging 200 files into one that i Have they all start with same headers from A1 to Q1 lines can very from 300 to 500 all files are .csv format Thank you in advance

I have a question about merging several lists but I think it would be easier to explain if I can show an example. Someone suggested I post a sample on Dropbox. How would I post a link to the file? Thanks

Hello, I have an excel workbook on my OneDrive folder that I want to share with some classmates -- I checked the box to "allow changes by more than one user at the same time - this also allows workbook merging". I did a test run and tried opening the excel workbook from two different...

Hi I just watched a youtube video about merging 2 excel sheets into a one sheet. all sheets are in the same files. the merge was done using Data tab-->Get External Data group --> From other sources-->Excel--> Microsoft Query. I tried to put these data into 2 different excel files and merge then...

We have a template that we use for merging and have come upon a weird glitch. We have a merge code for the Contact's Name and a merge code for their Company. We can see in the template that in one paragraph we do have the correct merge code for the name, but when we connect to the excel...

I have created a list of potential "skill sets" that leadership in my company may want to track. Now I have sent this list out to the leadership for review. The list is set up in the following manner: Skills down the 1st column. Career fields/specialty across the first row. Now I am asking...

Hello All, I am writing a code that does the 2 steps listed below, a total of 50 times. Below is a description of what the code does. Step 1) The code looks for a single cell to see if it is blank, or to be precise, if it is A1="". If the cell is empty (" "), then the code skips step 2 below...

Hi, I have searched through Mr. Excel and Google, and have reached an impasse. My original formula to add certain values in a list was: =SUMIF([Total Due], "110") + SUMIF([Total Due], "140") However, I need this to work as a SUBTOTAL function. I have tried several variations of the below...

Good evening, Currently I have been trying to write a Macro, activated via a ribbon-button, that will merge a series of excel workbooks into one worksheet. I have performed some research and the code presented below is what I have so far (which works as a macro within a workbook): Function...

Hello, This is my second posting for this problem... I apologize for "spamming". I would please like a VB code for making the first duplicate black font in each group of duplicates in a column. I will set the rest of the column to white font as default. (See Example) This is to avoid merging...

<tbody> Hello everyone, I have a question regarding Merging cells within a macro, in an attempt to remove the manual process I currently have to follow. I have a spreadsheet of multiple items, which have around 15 further variable in columns to the right. Each item...

Hello, I am new to this forum. Hope someone could help me with a merging problem in excel. Case: I have some huge workbooks with information like this: I would like the information in the cells into 1 row for each "group", so i want excel to merge the cells downwards until a new cell with...

I know this question has been asked and addressed in different ways, but I can't quite find what I'm looking for. To start off, I KNOW NOTHING ABOUT CODING. I'm hoping someone would be so kind as to help shave off hours at my work by showing me specific code that I can copy and paste into a...

Dear all,. I'm fairly new to VBA programming. I would like to merge 7 columns if two conditions are meet. Start Week Ending week Jan Feb Mar Apr May Jun July Aug Sept Oct Nov Dec 7 11 7 11 12 1 53 1 1...

Hi All, In my current job most of the time I have to open several pdf files to look for page(s) containing particular tag (say 'XYZ'), and then save/print each of that page individually. Once I have all the pages with that tag saved in one folder, I normally use pdf merger to merge them in one...

Excel 2010 <tbody> A B C D E F G H I J 2 Student Name ID Number Grade Days absent % Absent Number of Fs ODR (? no pass, truancy, class cuts) % Absent Number of Fs ODR (? no pass, truancy, class cuts) 3 sample, student 555142 10 0 0% 4 sample, student 555142 10 1 5% </tbody>...