Anyone have a direction they can point me in? I hope I'm coming across clearly.
#Indirect.ext excel 2010 64 bit how to
I'm guessing VBA is the only way to go, but I have no idea how to write it. I need to pull and fill information from different cells to 10 columns down 43 rows (each row representing a different WIP#.xls file).
But, I can't find a way to create a formula that will take this value and lookup the file to pull information from. xls to create the file name WIP12345.xls on Sheet2, and I have a Macro that copies and pastes special as value to turn the result into text. Once it has been approved, the summary workbook is updated with the WIP#. WIP12345.xls is an order form and completed days ahead. This is the setup needed The method works at the environment and tools I’m using, so if yours are a little bit different, your mileage may vary regardless, if you need help, just comment out on the comment section down below. WIP12345.xls is a form that holds information that needs to populate certain columns across row 2. One thing to note is that, regardless whether your machine is 32-bit or 64-bit, but when you download it, choose to install the 32-bit option. My problem when it comes to linking, is that the file path to pull the data from will not be known until part of the file name is entered into a cell.įor example, in 'Print Summary' workbook, Sheet1 Cell A2 is where the file name is entered as a number 12345 (and gets auto-formatted to place 'WIP' in front) which represents WIP12345.xls.
I've seen many questions on this forum about linking Excel files based on cell values and INDIRECT always pops up as an answer, and it does do function and fill my sheet the way that I want, but I need to find a way to work with the source file being closed.
0 kommentar(er)
