Hi all,
Im trying to pull the data from the last row in Column E of multiple files within a folder. I was initially looking to do this via vba but as I dont want to "open" each workbook individually it was suggest that power query may be the way forward. I am new to power query but have managed to work out how to pull all the files and even managed to work out how to get rid of the columns etc i dont need. what I cant work out is how to get the data from just the last row (which would be variable) of each workbook.
Can someone give me some pointers please.
Im trying to pull the data from the last row in Column E of multiple files within a folder. I was initially looking to do this via vba but as I dont want to "open" each workbook individually it was suggest that power query may be the way forward. I am new to power query but have managed to work out how to pull all the files and even managed to work out how to get rid of the columns etc i dont need. what I cant work out is how to get the data from just the last row (which would be variable) of each workbook.
Can someone give me some pointers please.
