VBA Code for combining data from 100's of Spreadsheets in to one base on Various Positions

[LISSANN]

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.

 

[dmt32]

Hi,
welcome to the forum
What you ask should be possible but the link to your example workbook is missing.

Dave

 

[LISSANN]

I apologize. I am just now seeing this response.

I am trying to link the example. I can tell you it is help a few people who are not excel savvy. I do not maintain the data but need to be able to pull from all the data on a regular basis. It is set up like word almost and there is not much in way of cosisitency in regards to formatting. There are header rows whose information needs to flow to each row, there are comments under the header rows, and there are subheader rows. I am pretty good with excel but I am not a genius. I need to help them with out them knowing I helped them. So they think they are still utilizing the same form, but can quickly pull information together if need be. So I need help.

 

[dmt32]

Without seeing your workbook one can only make guesses - If you have a dropbox place copy with some sample data & provide link here.
Plenty on forum to help you.

Dave

 

[LISSANN]

Below is the link to the example:

https://www.dropbox.com/s/qero5jwfqitfihd/BUDGET%20WORKBOOK%20EXAMPLE.xlsm?dl=0

 

[LISSANN]

Below is the link to the example:

https://www.dropbox.com/s/qero5jwfqitfihd/BUDGET%20WORKBOOK%20EXAMPLE.xlsm?dl=0

 

[LISSANN]

I apologize. I am just now seeing this response.

I am trying to link the example. I can tell you it is help a few people who are not excel savvy. I do not maintain the data but need to be able to pull from all the data on a regular basis. It is set up like word almost and there is not much in way of cosisitency in regards to formatting. There are header rows whose information needs to flow to each row, there are comments under the header rows, and there are subheader rows. I am pretty good with excel but I am not a genius. I need to help them with out them knowing I helped them. So they think they are still utilizing the same form, but can quickly pull information together if need be. So I need help.

That should say I am trying to help individuals who are not very excel savvy and myself at the same time.