merging data

Hi, I’m a bit of an Excel noob, so I hope I’m able to express myself clearly. Using Office Professional Plus 2019 on a Windows 10 computer. I'm working with a large dataset of TV show transcripts. Column A ('speaker') has the names of the characters, and column B ('line') has the lines they...

I'm trying to automate my data import method to save time. Right now 2 text files are created and saved in a folder before being opened in Excel, the required data highlighted and then copied and pasted into the relevant cells in the ROPdata sheet shown below. The first file is called...

Hi all, I have a list of data as follows: <tbody> A B C D E 1 NAME REFERENCES NAME (Sorted) REFERENCES (Sorted) 2 John <tbody> 36, 87, JR, 11, 26 </tbody> John JR, 4, 11, 26, 36, 85, 87, 96 3 Emily <tbody> 63, ES, 14, 1, 35 </tbody> Emily ES, 1, 14, 35, 63 4 Kate...

Hello everyone! First time poster here, so feel free to give me hell if I'm doing something wrong. Anywho, the question! I'm looking for a Macro that will: A - Grant selection of multiple files (Done) B - Automatically open and close selected files(Done) C - Copy the first sheet (Kinda done?)...

Im working on a project for my internship and need some help from you guys. I got all my data for my reports set up in a format of Months - - - - - - - - Years - - - - Im trying to set up a pivot table for each report and then merge them together to make a income statement...

Hi, I have a series of excel files in a folder that have the same Sheet1 format (column for date, ID, names etc) and I'd merge them into one long Sheet1 file instead. Additionally, I'd like to add an extra column with the file name from which each data value originated from, this way I can keep...

Hello there, I am needing some help on merging information from multiple sheets into one sheet. I am currently keeping track of averages for a racing club (horses) and at the end of each year, we pull all of the averages, and the top ten go to our finals. Is there any way to get the...