-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
#question
-
P
Update Query isn't working
Hello All, I'm trying to update a blank column in another table that is linked to sharepoint. I'm updating that table with names from a another table. I keep getting blank rows indiciting that the query isn't working can you please assist? Please see below: UPDATE [Historical Daily Hours JD]...- PWil84
- Thread
- #question
- Replies: 3
- Forum: Microsoft Access
-
K
Getpivotdata using "SUMIFS" FORMULA for Stock management.
=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 ...- krunal123
- Thread
- #excel #comparison #excel #formula #confused #excel #vba #checkin/out #inventoryreporting #pivot table#fiilter #pivot tables #tables #power query #question #sumifs pivot and power query
- Replies: 2
- Forum: Excel Questions
-
J
Report Import into One Column
Hello, In the past, I've gotten a lot of feedback and I'm hoping I have the same luck. I have a report that imports into a single column that I need broken down into multiple columns. What is the code to move the data within column a, separated only by space into the next column. E.g. "XXXX XXX...- Justijb
- Thread
- #columns #question
- Replies: 0
- Forum: Excel Questions
