Hi All,
I have just started VBA-ing in Excel, and feel I am way over my head. Any solution to the following would be greatly appreciated:
Basically, I have two two workbooks, let's call them data.xls, and model.xls
The model workbook needs to pull numbers from the data workbook. Basically the sheets in the data.xls workbook are a mirror image of what is in the model.xls (of course, the model.xls has additional sheets to manipulate the data etc.).
The reason the two workbooks exist is that the data.xls workbook is revised. The format remains the same but new files are generated every month.
Is it possible to link cells in the model.xls to the data.xls dynamically, such that whenever a new data.xls is place in the relevant folder, the model.xls worbook simply picks it up and then carries out whatever manipulation is required.
I hope this makes sense
Thanks!
I have just started VBA-ing in Excel, and feel I am way over my head. Any solution to the following would be greatly appreciated:
Basically, I have two two workbooks, let's call them data.xls, and model.xls
The model workbook needs to pull numbers from the data workbook. Basically the sheets in the data.xls workbook are a mirror image of what is in the model.xls (of course, the model.xls has additional sheets to manipulate the data etc.).
The reason the two workbooks exist is that the data.xls workbook is revised. The format remains the same but new files are generated every month.
Is it possible to link cells in the model.xls to the data.xls dynamically, such that whenever a new data.xls is place in the relevant folder, the model.xls worbook simply picks it up and then carries out whatever manipulation is required.
I hope this makes sense
Thanks!
