#power query

Hello: I have found this query, which works perfectly at giving me the ability to look at all of the queries currently built. let Source = #sections, Section1 = Source[Section1], convertTable = Record.ToTable(Section1) in convertTable Does anyone know how to update the...

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...

Hi all I am in a trouble to sort out the following to find out exact sum of the pay based on certain role and time period: In one sheet there are names of the positions and per period pay amounts In another sheet, there are positions and the names as well as their tenure/working period during in...

=GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,"")) I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result... Get pivot data using "SUMIFS" FORMULA for Stock management. HELP ...

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

Hello, I was wondering if anyone could help me with what is probably a very simple tweak. This currently takes a copy of my date column and changes all the dates to Sunday's date of whatever week that is. The trouble is that my weeks run Fri-Thu, so I need it to show the date of the Friday at...

# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

# How get Sum value via "HSN Code" vise ?????? Advance Condition : "if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts " (without pivotable / without filter/ without VBA)

Query : " HOW TO COMBINE " ITEMLIST " & USE IN DROPDOWN LIST (Condition : Inclued Both table "Item list" * Both Table "Item list is different * BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST . HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY. Note: I was make...

Hi All, Please go through with the screenshots. I was creating a custom Data Type by using a excel table data set. In final screenshot i got a #Field error, although non of the cell was blank in that selected entire data type row

How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...

I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.

# 1st Condition : MATCH Data 1st "SHEET 1 WITH '"SHEET 2" # 2nd Condition : "SHEET 2" MATCH DATA with other Workbook "SHEET 1" like this BOTH CONDITION MATCH AFTER SHOW ME STATUS " YES / NO " in Worksheet 2 > SHEET 1

# HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....

# How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"

I was try refresh but not show data in pivot table, how to update data ...???