Forum

Make sure the symbols are the ones that can be used in link. For example, you had symbols like: ABR.A, but the link needs to be ABR-PA for this symbol...

All you have to do is to paste symbols in the blue left table, and refresh the right green table. Make sure the symbols are correct, they need o be...

Try the attached version, there is one query for all symbols.

Hi Gary, You can try to open Excel in Safe Mode, this will not load any add-in, but power query will still be functional if it's excel 2016 and not...

Hi Jeremy, Can you upload a sample file with 3-4 queries only? There is no Table.Buffer in vba, it's a power query function, it should be used i...

Hi Koel, You can try this code: Sub DistributeSKU() Dim InvSheet As Worksheet, Orders As Worksheet, i As Long, RowIndex As Long, ColumnIndex A...

Then you should upload a sample file so we can see what's wrong, works on my side.

Hi Bill, Here is a code you can try: Sub GetCategory() Dim Dict As Object: Set Dict = CreateObject("scripting.dictionary") Dim i As Long, Ca...

If source columns are consecutive, try: Sheet2.Range("tblEnlisted[[Name]:[Index]]").Copy Destination:=Sheet7.Range("tblDay1[Column1]")

Hi Geoffrey, Try this version: let GetResults=(URL) => let Source = Web.Page(Web.Contents(URL)), #"Removed Other Columns" = Table.SelectCol...

Hi Abrar, You can try this formula, but I doubt that will work. A formula solution is not the best idea, try Power Query.

Hi, If you don't want the pivot to aggregate the data, you will have to add an index column in your source and display that in your pivot, in rows ...

You are close: =SUMIF($A$2:$A2,A2,$B$2:B2)

ok, i added the column I mentioned, had to unpivot first, as your data was on a horizontal layout.

Hi Srikanth, You can use the code written by macropod, can be used for word or pdf as well.