[SOLVED] Updated with workbooks. Lack of knowledge regarding importing data.

[atatbl]

Hi Everyone.

EDIT :Please disregard the Example HTML File. The Example data source file is where I need the information to update from. I imported it into excel and this is what it will look like when I work with it.... I added the colors. The purple-highlighted column is the number I need to automatically import to the Example Workbook file. I would like VBA to cross-reference (I'm not sure if that's the right word) the purple-highlighted info from the building numbers (green) to the corresponding spot in the Example Workbook. You will notice that the buildings numbers are the same, but not in the same order necessarily. Also the building numbers could change over months so I would like it to be able to address that.

Original:

I am looking to take info from a report saved on a drive and import it into excel when I push a button in excel. I think I know how to get Excel (VBA) to get the report and how to assign a button to a macro. However, I am not sure where to begin figuring out how to pull the data I need and get it to drop in the correct cell. I have done some research and that is the only reason I know how to do the other things above. So if someone can help me then awesome, if not, I would appreciate some resources that specifically address what I am talking about.

I have attached a Example Data Source after the HTML is imported into Excel. The "not" columns are useless data that are there. I am not sure if that matters. I need the "needed data" info (which will be numeric) from the building number row to import over to another sheet with corresponding building numbers. You will also notice a "Set" number in the Example Data Source. This number can change from month to month as well as which buildings fall into which "Set". I hope I am explaining this well enough. The building numbers on the report ARE NOT in the same order as on the spreadsheet. It will not work to change this.

I need the corresponding "needed data" from the building numbers in the Example Data Source to transfer over to the corresponding building number (one column to the right of it, to be precise, into the "NUMBER" column) in the excel sheet that I currently use. We are currently doing this manually

Any help here is appreciated!

Please ask me any questions that my explanation failed to address.