Hello All.
I've recently come across the power query feature in excel 2016 where in i got to know that i can extract data from multiple workbooks in a folder with actually having to open all those workbooks.
Now my question is, not sure whether it's possible or not, Can power query be used to extract specific rows of data from multiple workbooks?
For example if i want to extract the details only from the last two rows of all the workbooks in the folder, can this be done with power query?
The last 2 rows will be different in all the workbooks from which I'm extracting the data.
I've no idea on how power query works, as I'm still in the initial learning phase. So thats why posting my doubt here.
Thanks in advance.
I've recently come across the power query feature in excel 2016 where in i got to know that i can extract data from multiple workbooks in a folder with actually having to open all those workbooks.
Now my question is, not sure whether it's possible or not, Can power query be used to extract specific rows of data from multiple workbooks?
For example if i want to extract the details only from the last two rows of all the workbooks in the folder, can this be done with power query?
The last 2 rows will be different in all the workbooks from which I'm extracting the data.
I've no idea on how power query works, as I'm still in the initial learning phase. So thats why posting my doubt here.
Thanks in advance.