I am in a dilemma. Here`s my problem (hope I can make myself clear - I`m still learning my way through excel!)
In sheet one, if I enter the file path of a second workbook (e.g in cell A1), is there any way that the second workbook will pop up when I enter the file path??
Basically I want to take certain data out of the second workbook and paste it into the first and I want an easy way of doing it without writing a macro.
Is this at all possible or am I asking too much??
In sheet one, if I enter the file path of a second workbook (e.g in cell A1), is there any way that the second workbook will pop up when I enter the file path??
Basically I want to take certain data out of the second workbook and paste it into the first and I want an easy way of doing it without writing a macro.
Is this at all possible or am I asking too much??