Hello all,

I have a Pivot Table where I track my inventory purchases and negative adjustments during the month. I need to see the results only when there is a purchase, so if the Purchase field is blank, it should not be shown. Is there a way to do this? What I’ve been doing is copying and pasting and using formulas. However, this is not practical because ideally, I would like to view the information directly from the Pivot Table.

Thanks in advance.

​Hello all, I have a Pivot Table where I track my inventory purchases and negative adjustments during the month. I need to see the results only when there is a purchase, so if the Purchase field is blank, it should not be shown. Is there a way to do this? What I’ve been doing is copying and pasting and using formulas. However, this is not practical because ideally, I would like to view the information directly from the Pivot Table.  Thanks in advance.  Read More

​

Join Microsoft experts, industry trendsetters, and fellow business leaders in discovering new possibilities in AI when you attend Microsoft Ignite online November 19–21.  

You‘ll learn new skills, connect with partners, and explore Microsoft tools—including first looks at new AI technology—from wherever you are with a free online pass. 

Your online pass gives you access to the keynote livestream, live-streamed sessions, digital swag, and online experience features like:  

Session scheduler  

The attendee and featured partner directory 

Digital favorites 

On-demand keynotes and sessions 

Register now as a digital attendee to get your free online pass, then explore the session catalog to see what we have in store for you this year. 

Register for Ignite​

​Microsoft Tech Community – Latest Blogs –Read More 

Hi Friends,
Pls go thru my attached link carrying my file. I want that I will select any cell of allocated qty column (in “allocation vs rqd” sheet), in that row’s item code’s entity division(location), item name & godown wise qty should reflect in the same sheet (allocation vs rqd) automatically in a user form in a proper manner. And that data will be fetched from “Stock” sheet.
Even I filer any Data in the “allocation vs rqd” sheet that will not effect on that box , in spite of that if they select any cell of “allocated qty” column earlier that item’s data would be reflected in the same sheet ( in the box) that may be a pop up type box or a box can be kept aside where those data will be reflected even that data also should be copied if required.

Suppose I select S15 cell in “allocation vs rqd” sheet, then the data that would be reflected in that box is giving below

As in S15 cell is showing data of item Code IC7 & closing qty of that code is available in 3 numbers of godowns.
Hope You can understand what I mean to say.
It will be a great help if I get a solution on this.

Regards

Sanndip

https://www.dropbox.com/scl/fi/s28x8q1qi5mooxufd389k/trial.xlsx?rlkey=9pnpiz9kxx1g9j0at11ma2a2s&st=tv2yjoh4&dl=0

​Hi Friends,Pls go thru my attached link carrying my file. I want that I will select any cell of allocated qty column (in “allocation vs rqd” sheet), in that row’s item code’s entity division(location), item name & godown wise qty should reflect in the same sheet (allocation vs rqd) automatically in a user form in a proper manner. And that data will be fetched from “Stock” sheet.Even I filer any Data in the “allocation vs rqd” sheet that will not effect on that box , in spite of that if they select any cell of “allocated qty” column earlier that item’s data would be reflected in the same sheet ( in the box) that may be a pop up type box or a box can be kept aside where those data will be reflected even that data also should be copied if required.Suppose I select S15 cell in “allocation vs rqd” sheet, then the data that would be reflected in that box is giving belowEntity Division(Location)Item CodeItem NameUMGodownGodown NameClosing QuantityEL-3IC7IN7PCSGD8GN86EL-5IC7IN7PCSGD9GN9433EL-7IC7IN7PCSGD7GN76As in S15 cell is showing data of item Code IC7 & closing qty of that code is available in 3 numbers of godowns.Hope You can understand what I mean to say.It will be a great help if I get a solution on this.RegardsSanndiphttps://www.dropbox.com/scl/fi/s28x8q1qi5mooxufd389k/trial.xlsx?rlkey=9pnpiz9kxx1g9j0at11ma2a2s&st=tv2yjoh4&dl=0  Read More

​

Crypto.com Referral Code: 7t7zjawvje | Get 20% Rebate on Trading Fees for Lifetime

Take advantage of an amazing opportunity to save on Crypto.com by using the Referral Code: 7t7zjawvje. With this referral code, you’ll receive a 20% rebate on trading fees for a lifetime, making your trading experience more cost-effective and boosting your profits with every transaction.

Crypto.com is one of the most popular cryptocurrency exchanges globally, offering a wide variety of digital assets, easy-to-use features, and excellent security. With support for both beginners and professional traders, Crypto.com is a go-to platform for anyone looking to trade, invest, or even stake cryptocurrencies. And with the Crypto.com Referral Code, you can enjoy reduced fees for the long term.

Here’s why you should use the Crypto.com Referral Code:

Exchange Crypto.com

Referral Code7t7zjawvjeTrading Fee Rebate20%Rebate DurationLifetimeDate2024-25

To claim this fantastic offer, simply sign up on Crypto.com, create your account, and enter the Referral Code: 7t7zjawvje during registration. Once activated, you’ll receive a 20% rebate on trading fees for life, ensuring that you save money on every trade you make.

Whether you’re trading top cryptocurrencies like Bitcoin, Ethereum, or exploring new assets, Crypto.com provides a seamless platform with high liquidity, low fees, and plenty of trading options. Don’t miss out—sign up today using the Crypto.com Referral Code 7t7zjawvje and enjoy a lifetime rebate on your trading fees!

​Crypto.com Referral Code: 7t7zjawvje | Get 20% Rebate on Trading Fees for LifetimeTake advantage of an amazing opportunity to save on Crypto.com by using the Referral Code: 7t7zjawvje. With this referral code, you’ll receive a 20% rebate on trading fees for a lifetime, making your trading experience more cost-effective and boosting your profits with every transaction.Crypto.com is one of the most popular cryptocurrency exchanges globally, offering a wide variety of digital assets, easy-to-use features, and excellent security. With support for both beginners and professional traders, Crypto.com is a go-to platform for anyone looking to trade, invest, or even stake cryptocurrencies. And with the Crypto.com Referral Code, you can enjoy reduced fees for the long term.Here’s why you should use the Crypto.com Referral Code:Exchange Crypto.comReferral Code7t7zjawvjeTrading Fee Rebate20%Rebate DurationLifetimeDate2024-25To claim this fantastic offer, simply sign up on Crypto.com, create your account, and enter the Referral Code: 7t7zjawvje during registration. Once activated, you’ll receive a 20% rebate on trading fees for life, ensuring that you save money on every trade you make.Whether you’re trading top cryptocurrencies like Bitcoin, Ethereum, or exploring new assets, Crypto.com provides a seamless platform with high liquidity, low fees, and plenty of trading options. Don’t miss out—sign up today using the Crypto.com Referral Code 7t7zjawvje and enjoy a lifetime rebate on your trading fees!  Read More

​

Microsoft Teams has become one of the leading platforms for communication and collaboration in modern workspaces, especially as remote work has become more widespread. While Teams offers a plethora of features, users may occasionally encounter issues that can disrupt workflow. This guide outlines how to troubleshoot some of the most common Microsoft Teams problems, ensuring that you can get back to working smoothly in no time.

https://dellenny.com/how-to-troubleshoot-common-microsoft-teams-issues/

​Microsoft Teams has become one of the leading platforms for communication and collaboration in modern workspaces, especially as remote work has become more widespread. While Teams offers a plethora of features, users may occasionally encounter issues that can disrupt workflow. This guide outlines how to troubleshoot some of the most common Microsoft Teams problems, ensuring that you can get back to working smoothly in no time.
https://dellenny.com/how-to-troubleshoot-common-microsoft-teams-issues/
   Read More

​

Welcome to the October 2024 edition of our Microsoft Credentials roundup, where we highlight the latest portfolio news and updates to inspire and support your training and career journey. 
 

In this article 

What’s new with Microsoft Applied Skills? 

Explore the latest Applied Skills scenarios 

Applied Skills updates 

Take the Microsoft Learn AI Skills Challenge 

What’s new with Microsoft Certifications? 

Announcing the new Microsoft Certified: Fabric Data Engineer Associate Certification (Exam DP-700) 

New pricing for Microsoft Certification exams effective November 1, 2024 

Microsoft Certifications to be retired 

Build your confidence with exam prep resources 

Let’s talk about Applied Skills  

Want to have a bigger impact in your career? Explore Microsoft Applied Skills credentials to showcase your skills. According to a recent IDC study*, 50% of organizations find that micro-credentials like Microsoft Applied Skills help employees get promoted faster! 

*Source: IDC InfoBrief, sponsored by Microsoft, Skilling Up! Leveraging Full and Micro-Credentials for Optimal Skilling Solutions, Doc. #US52019124, June 2024 

Explore the latest Applied Skills scenarios  

We’re all about keeping you up to date with in-demand, project-based skills? Here are the new scenarios we’ve launched: 

Build distributed apps with .NET Aspire 

Build AI-powered solutions using Microsoft Azure Database for PostgreSQL 

Implement information protection and data loss prevention with Microsoft Purview 

Coming soon 

Stay tuned for the following Applied Skills and more at aka.ms/BrowseAppliedSkills: 

Implement retention, eDiscovery, and Communication Compliance in Microsoft Purview  

Develop data-driven applications by using Microsoft Azure SQL Database 

Applied Skills updates 

We ensure that Applied Skills credentials stay aligned with the latest product updates and trends. Our commitment to helping you build relevant, in-demand skills means that we periodically update or retire older assessments as we introduce new ones.  

Now available 

These assessments have been updated and are now back online:   

Create and manage canvas apps with Power Apps 

Create and manage automated processes by using Power Automate 

Create and manage model-driven apps with Power Apps and Dataverse 

Implement a Real-Time Intelligence solution with Microsoft Fabric 

Implement a data science and machine learning solution with Microsoft Fabric 

Implement a data warehouse in Microsoft Fabric 

Implement a lakehouse in Microsoft Fabric 

If you have been preparing for these credentials, go ahead and take the assessment today! 

Retirements  

Keep an eye out for new credentials in these areas. 

Retired: Build collaborative apps for Microsoft Teams 

Retiring on October 31st: Develop generative AI solutions with Azure OpenAI Service 

Take the Microsoft Learn AI Skills Challenge   

Dive into the latest AI technologies like Microsoft Copilot, GitHub, Microsoft Azure, and Microsoft Fabric. Explore six curated topics designed to elevate your skills, participate in interactive community events, and gain insights from expert-led sessions. Take your learning to the next level with a selection of the topics to earn a Microsoft Applied Skills Credential and showcase your expertise to potential employers. Start your AI journey today! 

Share Your Story 

Have you earned an Applied Skills credential that has made a difference in your career or education? Bala Venkata Veturi (see below) earned an Applied Skills credential through the #WICxSkillsReadyChallenge.

We’d love to hear from you! Share your story with us and inspire others with your journey. We could feature your success story next! 

What’s new with Microsoft Certifications?  

Announcing the new Microsoft Certified: Fabric Data Engineer Associate Certification (Exam DP-700) 

These days, as organizations strive to harness the power of AI, data engineering skills are indispensable. Data engineers play a pivotal role in designing and implementing the foundational elements for any successful data and AI initiative. To support learners who want to build and validate these skills, Microsoft Learn is pleased to announce the new Microsoft Certified: Fabric Data Engineer Associate Certification, along with its related Exam DP-700: Implementing data engineering solutions using Microsoft Fabric (beta), both of which will be available in late October 2024. Read all about this exciting news and explore other Microsoft Credentials for analytics and data science, in our blog post Prove your data engineering skills, and be part of the AI transformation. 

New pricing for Microsoft Certification exams effective November 1, 2024 

Microsoft Learn continually reviews and evolves its portfolio of Microsoft Certifications to help learners around the world stay up to date with the latest technologies, especially as AI and cybersecurity skills become increasingly important in the workplace. We also regularly update our exam content, format, and delivery. To reflect their current market value, we’re updating pricing for Microsoft Certification exams, effective November 1, 2024. The new prices will vary depending on the country or region where you take the exam. For most areas, there will be no change in the price. For some areas, the price will decrease to make the exams more affordable. For a few areas, the price will increase to align with global and regional standards. The goal is to make Microsoft Certification exam pricing simpler and more consistent across geographies while still offering a fair and affordable value proposition. Check out all the details in New pricing for Microsoft Certification exams effective November 1, 2024. 

Microsoft Certifications to be retired 

As announced in Evolving Microsoft Credentials for Dynamics 365, the following Certifications will be retired on November 30, 2024: 

Microsoft Certified: Dynamics 365 Sales Functional Consultant Associate (Exam MB-210) 

Microsoft Certified: Dynamics 365 Customer Insights (Journeys) Functional Consultant Associate (Exam MB-220) 

Microsoft Certified: Dynamics 365 Customer Insights (Data) Specialty (Exam MB-260) 

If you’re currently preparing for Exam MB-210, Exam MB-220, or Exam MB-260, we recommend that you take the exam before November 30, 2024. If you’ve already earned one of the Certifications being retired, it will remain on the transcript in your profile on Microsoft Learn. If you’re eligible to renew your certification before November 30, 2024, we recommend that you consider doing so. 

Build your confidence with exam prep resources 

To better prepare you to earn a new Microsoft Certification, we’ve added new Practice Assessments on Microsoft Learn, including:  

Exam MB-335: Microsoft Dynamics 365 Supply Chain Management Functional Consultant Expert  

Exam MB-500: Microsoft Dynamics 365 Finance and Operations Apps Developer Associate  

Exam MB-800: Microsoft Dynamics 365 Business Central Functional Consultant Associate  

Watch this space for the next Microsoft Credentials roundup as we continue to evolve our portfolio to help support your career growth.  

Follow us on X and LinkedIn, and make sure you’re subscribed to The Spark, our LinkedIn newsletter.   

Previous editions of the Microsoft Credentials roundup  

June 2024 

March 2024 

February 2024 

January 2024 

​Microsoft Tech Community – Latest Blogs –Read More 

Im trying to make a macro to copy the content of existing word documents into a newly made one. When I run it in seperate pieces it works, but when i put it together it won’t make a new document and only opens a blank word aplication (and I get error -2147417848(80010108) ). When the first document it copies from is already open it does, but then it won’t copy the text anymore (and i get error 4198). I can’t find a solution and I’m at my limit of knowlage about VBA.

Sub button1()
Dim wdApp As Object
Dim wdDoc As Object
Dim newWdDoc As Object
Dim path As String
Dim docContent As Object

Set wdApp = CreateObject(“Word.Application”)
wdApp.Visible = True

Set newWdDoc = wdApp.Documents.Add
newWdDoc.Activate

If Sheets(“Keuze”).Cells(2, 2).Value = True Then

path = Sheets(“Verwijzing”).Cells(1, 1).Value
Set wdDoc = wdApp.Documents.Open(path)

wdDoc.content.Copy
newWdDoc.Activate
newWdDoc.content.Paste

wdDoc.Close False
End If

If Sheets(“Keuze”).Cells(2, 3).Value = True Then

path = Sheets(“Verwijzing”).Cells(1, 2).Value
Set wdDoc = wdApp.Documents.Open(path)

wdDoc.content.Copy
newWdDoc.Activate
newWdDoc.content.Paste

wdDoc.Close False
End If

If Sheets(“Keuze”).Cells(2, 4).Value = True Then
path = Sheets(“Verwijzing”).Cells(1, 3).Value
Set wdDoc = wdApp.Documents.Open(path)

wdDoc.content.Copy
newWdDoc.Activate
newWdDoc.content.Paste

wdDoc.Close False
End If

newWdDoc.SaveAs2 “C:UsersUserDocumentenWordnewWdDoc”

newWdDoc.Close False
wdApp.Quit

Set wdApp = Nothing
Set wdDoc = Nothing
Set newWdDoc = Nothing
End Sub

Thank you in advance for taking time to look at this probably overcomplicated code.
-Bram

​Im trying to make a macro to copy the content of existing word documents into a newly made one. When I run it in seperate pieces it works, but when i put it together it won’t make a new document and only opens a blank word aplication (and I get error -2147417848(80010108) ). When the first document it copies from is already open it does, but then it won’t copy the text anymore (and i get error 4198). I can’t find a solution and I’m at my limit of knowlage about VBA.Sub button1()
Dim wdApp As Object
Dim wdDoc As Object
Dim newWdDoc As Object
Dim path As String
Dim docContent As Object

Set wdApp = CreateObject(“Word.Application”)
wdApp.Visible = True

Set newWdDoc = wdApp.Documents.Add
newWdDoc.Activate

If Sheets(“Keuze”).Cells(2, 2).Value = True Then

path = Sheets(“Verwijzing”).Cells(1, 1).Value
Set wdDoc = wdApp.Documents.Open(path)

wdDoc.content.Copy
newWdDoc.Activate
newWdDoc.content.Paste

wdDoc.Close False
End If

If Sheets(“Keuze”).Cells(2, 3).Value = True Then

path = Sheets(“Verwijzing”).Cells(1, 2).Value
Set wdDoc = wdApp.Documents.Open(path)

wdDoc.content.Copy
newWdDoc.Activate
newWdDoc.content.Paste

wdDoc.Close False
End If

If Sheets(“Keuze”).Cells(2, 4).Value = True Then
path = Sheets(“Verwijzing”).Cells(1, 3).Value
Set wdDoc = wdApp.Documents.Open(path)

wdDoc.content.Copy
newWdDoc.Activate
newWdDoc.content.Paste

wdDoc.Close False
End If

newWdDoc.SaveAs2 “C:UsersUserDocumentenWordnewWdDoc”

newWdDoc.Close False
wdApp.Quit

Set wdApp = Nothing
Set wdDoc = Nothing
Set newWdDoc = Nothing
End SubThank you in advance for taking time to look at this probably overcomplicated code.-Bram  Read More

​

Dear Tech Community , I am using Azure API Management (APIM Basic) in external mode and without VNet integration, meaning my API instance is publicly accessible through the default …azure-api.net subdomain. I’m also using a custom domain but the default domain still remains aktive.

I am concerned about potential DDoS attacks and want to secure this subdomain. I am considering using Azure Front Door to filter the traffic and leverage its Web Application Firewall (WAF) for enhanced protection.

Could you please clarify the following:

Is it possible to fully protect the API subdomain (…azure-api.net) via Azure Front Door or other products, ensuring no traffic bypasses Front Door and directly reaches the original APIM domain?What additional configurations, such as IP filtering or header validation, are required to restrict access so that only traffic routed through Azure Front Door reaches the APIM domain?Given that API Management without VNet integration doesn’t support DDoS Protection Standard, what are the best practices for DDoS protection in this scenario?Could you recommend any additional steps or configurations to ensure that all DDoS and security measures are effectively implemented?

Thank you for your support.

Best regards Michael

​Dear Tech Community , I am using Azure API Management (APIM Basic) in external mode and without VNet integration, meaning my API instance is publicly accessible through the default …azure-api.net subdomain. I’m also using a custom domain but the default domain still remains aktive.I am concerned about potential DDoS attacks and want to secure this subdomain. I am considering using Azure Front Door to filter the traffic and leverage its Web Application Firewall (WAF) for enhanced protection.Could you please clarify the following:Is it possible to fully protect the API subdomain (…azure-api.net) via Azure Front Door or other products, ensuring no traffic bypasses Front Door and directly reaches the original APIM domain?What additional configurations, such as IP filtering or header validation, are required to restrict access so that only traffic routed through Azure Front Door reaches the APIM domain?Given that API Management without VNet integration doesn’t support DDoS Protection Standard, what are the best practices for DDoS protection in this scenario?Could you recommend any additional steps or configurations to ensure that all DDoS and security measures are effectively implemented?Thank you for your support.Best regards Michael   Read More

​

I have a policy that requires specific tag with specific values (json below), but I want to require more tags within the same policy also with specific value and not sure how to do it…

Is there a way to add more tags with specific values to the same policy?

For example, I want to require two tags:

environment with prod/non-prod and department with Infra/Finance

Is it possible?

Thank you!

​I have a policy that requires specific tag with specific values (json below), but I want to require more tags within the same policy also with specific value and not sure how to do it… Is there a way to add more tags with specific values to the same policy?For example, I want to require two tags:environment with prod/non-prod and department with Infra/Finance Is it possible?Thank you! {  “properties”: {    “displayName”: “Require tag environment and its values on resources “,    “policyType”: “Custom”,    “mode”: “Indexed”,    “description”: “Enforces a required tag environment and its value. Does not apply to resource groups.”,    “metadata”: {      “category”: “Tags”,      “createdBy”: “”      “createdOn”: “”      “updatedBy”: “”      “updatedOn”: “”    },    “version”: “1.0.0”,    “parameters”: {      “tagName”: {        “type”: “String”,        “metadata”: {          “displayName”: “Tag Name1”,          “description”: “Name of the tag, such as ‘environment'”        },        “allowedValues”: [          “environment”        ]      },      “tagValue”: {        “type”: “Array”,        “metadata”: {          “displayName”: “Tag Value1”,          “description”: “Value of the tag, such as ‘production'”        },        “allowedValues”: [          “prod”,          “non-prod”        ]      }    },    “policyRule”: {      “if”: {        “not”: {          “field”: “[concat(‘tags[‘, parameters(‘tagName’), ‘]’)]”,          “in”: “[parameters(‘tagValue’)]”        }      },      “then”: {        “effect”: “deny”      }    },    “versions”: [      “1.0.0”    ]  },  }}  Read More

​

I noticed in my Table of Contents that some of the headings have no space before the first dot and other headings have 1 space before the dot.  I’ve looked at other documents and theirs were the same way.  Why is that and is there a solution?

​I noticed in my Table of Contents that some of the headings have no space before the first dot and other headings have 1 space before the dot.  I’ve looked at other documents and theirs were the same way.  Why is that and is there a solution?  Read More

​