Hi All,
Master File I refer to is this Pro Fee Tool.xlsm
Filepath - C:\Users\Suhail\Documents\Work\Pro Fee Dash Board\Pro Fee Tool.xlsm
Context:
In my master file ‘Pro Fee Tool’ column A as of row 3 all the way down for a good several thousand rows will contain a unique ‘SOW – Name’. The rest of the table to the right will be empty.
Now, for each of the 'SOW - Name' rows in A, there will be a separate file pertaining to that unique ‘SOW – Name’ where I can pull the associated data mentioned in the headers in the columns to the right of A (example of the file attached below). The files are all stored in the same folder with the same filepath just the Workbooks vary in name, so the folder contains 1000’s of files like this [String from Column A].xlsx
I have uploaded an example of the data workbook here Payments ADM.xlsx
filepath - C:\Users\Suhail\Documents\Work\Pro Fee Dash Board\Pro Fee Tool Data Files\Payments ADM.xlsx
in general filepath - C:\Users\Suhail\Documents\Work\Pro Fee Dash Board\Pro Fee Tool Data Files\[String from Column A].xlsx
The Goal:
using vba code, I would like it to look up the value in column A, open the associated file to that string, copy paste the data in the respected columns and loop and do this for all the data in column A: ‘SOW – Name’, and close these data files I don't want 100 files opened after executing the code.
The SOW – Name in the Pro Fee Tool File will not always be 5 rows apart, some will be more some less. In the actual file I am working with you see why but I removed that part for the sample as it gets complicated. But regardless of them being separated at a variable amount of rows I know that using a Find, Match and Offset function that the data can be pasted in the right spots. The column headers in the Data Sheet are identical to that of the Pro Fee Tool ones so using these Find, match, hlookup functions will work.
Also every single data sheet will be the exact same formatting with 1 row like that, just the data will change based on the SOW Name.
Sorry for the long post . Are there any Gurus out there that can help me?? Anything would help Thank you in advance for taking your time to help !
Bookmarks