I have a report that has individual data set up in form format, however, I want to pull the information from each of the worksheet into a data minable spreadsheet without having to reformatted each individual spreadsheet. Is this possible. I have attached an example.
As you can see it is not in single row format for basic VBA combining code, so I am confused. I have numerous reports (formatted in this manner) that contain almost three hundred individual reports. I need to format each into one data minable master sheet.
Any assistance would be greatly appreciated.
As you can see it is not in single row format for basic VBA combining code, so I am confused. I have numerous reports (formatted in this manner) that contain almost three hundred individual reports. I need to format each into one data minable master sheet.
Any assistance would be greatly appreciated.
