combine data

I have a workbook with sheets for each financial year from 2010 onwards. All column headers are the same across all sheets. I need to be able to combine all the sheets into one sheet *BUT* I need this combined sheet to change with the others if rows are added/deleted in any of the other sheets...

Hello, I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in Column H. Since each carrier tracking has similar link formatting, I would copy their link, but just need to change the tracking # part of it ... for example...

Hello, I have searched the boards for what seems like hours and I can not find anything to help me. I need to group 3 columns of data. The first 2 columns (group number and store number) must stay paired (they are a required combination) but I need to create the 3rd column to loop through a...

Hello Gurus, Good day! Could you possibly help me tweak below code? I have multiple workbooks and need to combine into one. I have below code that can do it. However, I am getting an error message whenever there is same tab name that exists on different workbook. Note that the tab name most...

I have six columns with anywhere from 5 rows to 99 rows in each column. I need to combine EVERY possible combination of the rows. Here's some of the data. I know how to concatenate, but don't think that is what I need to do. Please help!! <tbody> Entity Location Department GL Account Fund...

Hello, I have a two part question which i'm hoping someone can help with. I am going to need to combine/append several hundred tables into single tables for use. In this case i am asking users to complete their own weekly information into 3 tables within a worksheet. There are several hundred...

Hello, I'm new to the forum so thank you in advance for your help. I'm trying to use the loop function to extract and aggregate data across clients and can really use some help with my VBA code - I'm not sure where I am going wrong. Here is what I have and am trying to do - 1) I have about 75...

Hello! I have one table with states on the left hand side going down and odd numbers on the top going across. I have another tables with states on the left hand side going down and even numbers on the top going across. It looks like: 1 3 5 7 ... AK x...

Hi all, I have a macro that combine data from a column into a cell. The macro ask to enter a separator in an inputBox and then combine all the data from a column range in a cell separated by the separator of interest. Now I want to combine my data in selection with "alt-enter". I am not sure...

Hi I would like to combine multiple excel workbooks (sheet2 only) in 1 workbook. Would appreciate some guidance if possible

I have two sheets, both sheets have the client account numbers, but one has the phone, email and name, and the other has the name and address. I need to add the address to the sheet with the phone and email. There are other a thousand records so doing this manually is not ideal. Can someone...

I see a variety of code for what I am looking to do. Ron de bruin's code is almost exactly what I need, but need help with part of it as the row range must be dynamic. I have 20+ workbooks with different names in one folder. I need to stack the data from each workbook into one worksheet in a...

Hi All, I have a workbook with 4 sheets. Each sheet has data in 10 columns. all sheets column headers are same. I want to consolidate selective column (A: C, F:H) data from all four sheets into a new sheet under the same column header. I have a code, but it is copying the entire columns from...

Good Evening, I have an excel export containing columns A through R. What I need is a macro that will run through to last row of data and merge rows based on like values in certain columns. For example: If Column A,B,C & F match then merge rows. However, some columns may have information...

Hi, I'm trying to combine data that I have on 62 worksheets in my workbook. I've got the Macro working that pulls in my data from cells A4:P:66, and only puss in the info if they have data, but I can't figure out how to add the worksheet name to the end of the data on my "Import" worksheet, so...

Hi, I have to update two raw files each day and then combine them One file has 1600 or so rows and the other has 250. Each day this increases. I usually copy and paste the raw files into the same workbook each day and then combine them. I was wondering is there some code that could combine...

Hello everyone, Is there a way I could combine the data from two columns in one field in PIVOT table? The data looks something like this: <tbody> Product A Product B Quantity - product A Quantity - product B ID14 ID2 10 4 ID14 12 ID2 10 ID16 ID14 20 7 ID17 ID16 10 11 </tbody>...

Hi, I was hoping someone could help me with a VBA code that would combine text and data from excel to a word document. I have unsuccessfully modified & combined code from examples I have found online, and would appreciate any help you can provide. If possible, could you please add comments to...

Hi Folks Just wondering if someone can help me speed up a process. In the attached sheet you will see some sets of soccer results which I type in as text on sheet 1. What I want to do is combine the sets of results from both teams in order to find the most likely scoreline at full time,and...

Hello, The idea is simple the execution not so i guess :) I have a large number of sheets with 2 rows: the first has the headers in it the second has a number of values the first column contains a unique article number What i would like to do is have a script that adds all these rows below...