bringing

Hi all, I think this is probably quite simple, but google searches are bringing up something slightly different to what I want. I have an accounts sheet, columns A-C are income, E-G are outgoings. I want to sort income by date, which is column A, and the outgoing by date, which is column E...

Hi Guys, I just discovered the "query" section under data and would like to use it to get averages of values across multiple excel files in a certain folder. Im trying to start simple, just one file in the folder and bringing in what is called "Table9" into the editor. The problem in all my...

Hi all. This is my first post and I am Hoping someone can help.i am building a report and in the report I am attaching a hyperlink to a column that contains a part number. The hyperlink is a link to the part on my company website. The issue I am encountering is after the hyperlink is clicked it...

I need a non-VBA solution to bringing objects to the front (or making visible, etc.).

Hi Is there a limitation on the number of cells you can import? I have a file with 209 columns and 500 rows but PowerQuery is only bringing in the first 128 rows - is there a workaround to this? Many thanks

Hi, I have the following formula which doesn't seem to bring anything back, can anyone help...