combine data

I have a large excel spreadsheet where I need to merge rows on a unique identifier. I'm trying to develop an Excel VBA macro but still lack the proficiency to tackle this. Here is a picture of an example of what I'm trying to do. The data including the headers are all made up for the example...

Can I combine select text from independent responses in different excel cells, similar to how independent clauses are combined in English grammar using commas and conjunctions (Bob is bad. Billy is bad.-->Bob and Billy are bad.)? I have a spreadsheet with values populated by a survey asking...

Hello everyone, I would like to combine the data of some 12 sheets into one sheet. All data of every column should be present in the final sheet (this can become some 40 - 50 columns). The data of the columns with similar names should be merged across all (duplicate header names) columns...

Here is an interesting one... I need to create a file name... it uses several fields to make one value. Consider something like this... Cell Data Info -------------------------------------------------------------------------------------------------------------- A1...

Hello, I am new to VBA in excel and i hope i can find some help here :) Ok so before i start with the problem i have a macro which takes the results generated and puts them into a table and filters the data so that zeros does not show and arranges the table from largest to smallest. Now i...

I have two worksheet in excel file. in Sheet 1, there are Identity in Column A and Names on Column B. In Sheet 2 there is Identity in Column A and Score in Column B. There are 45000+ records (rows) in Sheet 1 and 22000+ records (rows) in Sheet 2. Mean Sheet 2 is half from Sheet 1. I want to put...

Thank you for a great resource! I have combed through the posts on combining data, but could not find one that addressed this issue: Data set 1 includes fname, lname, and 10 other fields; <tbody> Fname Lname Gender Race Data1 Data2 Data3 Data4 Data5 Jane Doe F W xxx xx...

Hello I'm a bit of a noob and need some help! I have 2 property spreadsheets to combine, the both have roughly the same data but both have some missing compared to each other and most data has been changed/updated. So I wish to combine and update both into a master spreadsheet without creating...

Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column titles are the same. Every workbook was sent to me "shared", which has created several limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this...

Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column tabs are the same. Every workbook arrived "shared", which has created limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this when it is not...

Hi I have question about sorting data in a report. I will start and explain in detail what I have and what i want. I made an excel invoice workbook: sheet1 is the template, and sheet2 is the transactions. In sheet1 I made a regular invoice template, Then I created a macro that should print...

Hi All I am going to start from scratch here Do anyone know how to create a macro that will combine all files (xlsm) in a folder and save but for 89 separate folders??? eg I have Folder1, Folder2, Folder3 etc 89 in total Each folder has files Folder1A, Folder1B, Folder1C etc (xlsx) I want...

Hi All New to the forum, please be gentle with me... Please see the macro below I found this combine macro found on the internet, it works perfectly on its own The Macro combines all the files in a particular folder and saves it as one However, I need it to combine the files in 89 separate...

Hello, Am attempting to report tickets that are currently open and were created within a certain time range. The problem arises when I attempt to eliminate items that were opened and closed within the same date range. The current formula is =COUNTIF('name of tab'!$B$!:$B$100, "1") where 1...

Hi All. Is it possible to combine a small amount of text followed by a formula in the same cell. Each month I summarise a number of lines into one line so that my spreadsheet doesn't get too large. What I'd like to do is have the summary as a running total throughout the month BUT I don't want...

I have 2 worksheets, one with about 500 lines and the other with 1600 lines. The first worksheet - the target with 500 lines, I have a firstname/last name combined field in column C. In column D I need to obtain the status of each of these people from my second worksheet. I've pasted the...

Please forgive me if this is a bit simple for you guys, but I am new here and despite looking through lots of threads I can't find the answer to my problem. I have been presented with a spreadsheet of ticket purchases in which all the quantities are 1. If more than 1 ticket was purchased by a...

Hi, I have a data that is in many seperate worksheets (150+) which i need to combine to make a database in one sheet (the seperate sheets are just from different dates samples were taken). What i wanted to ask the forum is the best way of doing this. The problem i have is through column and...

How can I combine data from separate spreadsheets into one pivot table or any other reporting method? The only common data field is “name.” In each spreadsheet there are multiple rows of data associated with each name. How can I produce a report which includes all the following in one document...