I have a workbook with a macro - when a user clicks on the "obtain values" button, it will open a dialog box where they select files. Once those files are selected, the macro will extract specific data from each of these files, and input them into the respective worksheets inside the "TAO Analysis - Beta" file. It will identify which worksheet it needs to input data into based on the filename.
i.e. filename = 205 (ABC) will search for company ABC on worksheet 205, and input the data in pink (data below)
Data needed = columns G:J (dollars only, not hours), column AS, AU, AX, and BG.
Column G will always be triggered by the reporting period (cell B5) on the 205/206 files.
The macro I have in there I copied over from another workbook I use. I'm having difficulty tweaking it for the TAO Analysis workbook. I have not assigned the macro yet to the button.
I'm really trying to learn how to do this, but am stuck understanding the extracting portion of the macro. It will be greatly appreciated if anyone can help me.
I have 3 sample files. It doesn't look like I can attach them here. Looks like I'd have to email it to someone.
i.e. filename = 205 (ABC) will search for company ABC on worksheet 205, and input the data in pink (data below)
Data needed = columns G:J (dollars only, not hours), column AS, AU, AX, and BG.
Column G will always be triggered by the reporting period (cell B5) on the 205/206 files.
The macro I have in there I copied over from another workbook I use. I'm having difficulty tweaking it for the TAO Analysis workbook. I have not assigned the macro yet to the button.
I'm really trying to learn how to do this, but am stuck understanding the extracting portion of the macro. It will be greatly appreciated if anyone can help me.
I have 3 sample files. It doesn't look like I can attach them here. Looks like I'd have to email it to someone.
