Hello everyone! New member here excited to hear what you guys have to offer!
I am currently working on creating a "Master Excel File" That will merge all of my excel files in the designated folder of my choosing. I currently have 90 Excel files that I am trying to merge to create the master file, and more files will be added in the future(I guess thats the implication this will be a reused macro ideally, not a one time use merge). Each file represents one item that we are gathering data from, and each sheet represents data rom a particular characteristic of the item. Currently each file in this folder I am trying to merge has 11 sheets that are named the same. I am using a PowerShell Script that adds columns for File Name and other things to identify it, so my goal is to have one file that I can run this script on that will allow me to select the files to merge, and the script will bring the data from all of these files into one(Example: We are trying to detect knots in wood, so every file has a sheet called "Knot 2". We want the master file to have one Knot 2 sheet that will have the data from every board we are getting data from)
I do not mind posting excel files for testing or testing code and collaborating with people, thank you for your support!
I am currently working on creating a "Master Excel File" That will merge all of my excel files in the designated folder of my choosing. I currently have 90 Excel files that I am trying to merge to create the master file, and more files will be added in the future(I guess thats the implication this will be a reused macro ideally, not a one time use merge). Each file represents one item that we are gathering data from, and each sheet represents data rom a particular characteristic of the item. Currently each file in this folder I am trying to merge has 11 sheets that are named the same. I am using a PowerShell Script that adds columns for File Name and other things to identify it, so my goal is to have one file that I can run this script on that will allow me to select the files to merge, and the script will bring the data from all of these files into one(Example: We are trying to detect knots in wood, so every file has a sheet called "Knot 2". We want the master file to have one Knot 2 sheet that will have the data from every board we are getting data from)
I do not mind posting excel files for testing or testing code and collaborating with people, thank you for your support!
