I'm hoping somebody can point me in the right direction. I know how to extract data from another workbook on a server location using VBA.
But I'm afraid what I need may be a little more advanced than my ability.
I'm currently learning VBA for my company and I have a tool that compares a lot of data from other files and makes sure they all match.
I want to be able to type in a DR #in a field below. And VBA find the last used row in column B... and use that number in the cell as a search query to find a specific row in another workbook. Then copy the entire row back into another sheet in my tool workbook. The other workbook columns are fixed so I can manage to get it to copy/paste the data into the proper fields on my own. I think...
Thanks in advanced.
But I'm afraid what I need may be a little more advanced than my ability.
I'm currently learning VBA for my company and I have a tool that compares a lot of data from other files and makes sure they all match.
I want to be able to type in a DR #in a field below. And VBA find the last used row in column B... and use that number in the cell as a search query to find a specific row in another workbook. Then copy the entire row back into another sheet in my tool workbook. The other workbook columns are fixed so I can manage to get it to copy/paste the data into the proper fields on my own. I think...
Thanks in advanced.