Hello all,
I'm sure there is a simple answer yes or no this this one, but I've been spending the last couple of days on the internet trying to find the answer to this...
I have a large number of excel workbooks which contain data in specific cells. I need to get these into a single output table. Is it possible for PowerQuery in Excel to pull, just for example,
cell F80 and cell G62 from each of the workbooks I have in a directory (maybe 100 workbooks)?
The source data in these cells is not in a named range or an excel table, nor is there any text that uniquely identifies the contents of the cells
I can actually do this fairly easy using VBA, but eventually have to hand over to a non VBA person,and was thinking PowerQuery might be able to do this.
When I've tried, it seems that Powerquery filters out blank rows, so doesn't pull data from where I expect...
Any thoughts on this - I've got a feeling I must be missing something obvious??
Many thanks in advance,
Shaun
I'm sure there is a simple answer yes or no this this one, but I've been spending the last couple of days on the internet trying to find the answer to this...
I have a large number of excel workbooks which contain data in specific cells. I need to get these into a single output table. Is it possible for PowerQuery in Excel to pull, just for example,
cell F80 and cell G62 from each of the workbooks I have in a directory (maybe 100 workbooks)?
The source data in these cells is not in a named range or an excel table, nor is there any text that uniquely identifies the contents of the cells
I can actually do this fairly easy using VBA, but eventually have to hand over to a non VBA person,and was thinking PowerQuery might be able to do this.
When I've tried, it seems that Powerquery filters out blank rows, so doesn't pull data from where I expect...
Any thoughts on this - I've got a feeling I must be missing something obvious??
Many thanks in advance,
Shaun
