​Here are the steps to complain against a Navi loan:1. Contact Navi loan Customer Contact Us: 09241-484.599.., Reach out to Navi’s customer service team either by phone, email, or through their website’s customer support portal. Explain the issue you are facing with your loan and request to file a formal complaint.2. Submit a Written Complaint: Follow up your verbal complaint with a written complaint. This can be done by sending a letter or email to Navi’s customer service or complaints department. Clearly state the details of your issue, any relevant documentation, and the resolution you are seeking.3. Escalate to Navi’s Grievance Redressal Officer: If your complaint is not satisfactorily resolved by the customer service team, you can escalate it to Navi’s Grievance Redressal Officer. Their contact details should be available on Navi’s website or provided to you.4. File a Complaint with the RBI: If Navi does not address your complaint within a reasonable time or you are not satisfied with their response, you can file a complaint with the Reserve Bank of India (RBI) Consumer Education and Protection Department. You can do this through the RBI Complaint Management System.5. Approach the Banking Ombudsman: If the RBI is unable to resolve your complaint, you can approach the Banking Ombudsman, which is an independent dispute resolution authority set up by the RBI. The Ombudsman can help mediate and resolve your complaint against Navi.Remember to keep copies of all your communication and documentation related to the complaint. This will help strengthen your case if the matter needs to be escalated further. Stay persistent and follow the proper channels to get your issue resolved.  Read More

​

How can I replace the original row in “list orders export” with the rows in Sheet 3 and Sheet 4? This should be based on the name / data in the column B, in this example, “UBS Switzerland AG”

i.e. List orders export has row 90 that is UBS entry

The two other numbered sheets have 2 different UBS row entries

I want to delete the original Row 90 and add these 2 new rows from different sheets respectively to the bottom of the “list orders export” sheet

I have this code, but it manually checks for the “UBS xxx” text instead of dynamically using input in Column B…

investorName = “UBS Switzerland AG”
can I set this to a column, for example, column B in “Sheet2”?

so it searches for the name in Column B of Sheet2 in both List orders export AND sheet3, and replaces the entry with that name in list orders export with the 2 entries from sheet2 and sheet3 respectively

Sub ReplaceUBSRow()
Dim wsExport As Worksheet
Dim wsSheet2 As Worksheet
Dim wsSheet3 As Worksheet
Dim investorName As String
Dim lastRow As Long
Dim targetRow As Long
Dim i As Long
Dim foundRow As Long

‘ Set the investor name to search for
investorName = “UBS SWITZERLAND AG”

‘ Set references to the sheets
Set wsExport = ThisWorkbook.Sheets(“List Orders export”)
Set wsSheet2 = ThisWorkbook.Sheets(“Sheet2”)
Set wsSheet3 = ThisWorkbook.Sheets(“Sheet3”)

‘ Find the row with UBS Switzerland AG in the “Export Order List” sheet
lastRow = wsExport.Cells(wsExport.Rows.Count, “B”).End(xlUp).Row
foundRow = 0
For i = 1 To lastRow
If wsExport.Cells(i, 2).Value = investorName Then
foundRow = i
Exit For
End If
Next i

‘ If the row is found
If foundRow <> 0 Then
‘ Delete the found row
wsExport.Rows(foundRow).Delete

‘ Define new rows to insert
Dim newRow1 As Range
Dim newRow2 As Range

Set newRow1 = wsSheet2.Rows(2) ‘ assuming data is in row 2
Set newRow2 = wsSheet3.Rows(2) ‘ assuming data is in row 2

‘ Insert rows from “Sheet2” and “Sheet3” into “Export Order List”
wsExport.Rows(foundRow).Insert Shift:=xlDown
wsExport.Rows(foundRow).Insert Shift:=xlDown

‘ Copy data from “Sheet2” and “Sheet3” to “Export Order List”
newRow1.Copy Destination:=wsExport.Rows(foundRow)
newRow2.Copy Destination:=wsExport.Rows(foundRow + 1)
End If
End Sub

​How can I replace the original row in “list orders export” with the rows in Sheet 3 and Sheet 4? This should be based on the name / data in the column B, in this example, “UBS Switzerland AG” i.e. List orders export has row 90 that is UBS entryThe two other numbered sheets have 2 different UBS row entriesI want to delete the original Row 90 and add these 2 new rows from different sheets respectively to the bottom of the “list orders export” sheet I have this code, but it manually checks for the “UBS xxx” text instead of dynamically using input in Column B…investorName = “UBS Switzerland AG”can I set this to a column, for example, column B in “Sheet2”?so it searches for the name in Column B of Sheet2 in both List orders export AND sheet3, and replaces the entry with that name in list orders export with the 2 entries from sheet2 and sheet3 respectively Sub ReplaceUBSRow()Dim wsExport As WorksheetDim wsSheet2 As WorksheetDim wsSheet3 As WorksheetDim investorName As StringDim lastRow As LongDim targetRow As LongDim i As LongDim foundRow As Long’ Set the investor name to search forinvestorName = “UBS SWITZERLAND AG”‘ Set references to the sheetsSet wsExport = ThisWorkbook.Sheets(“List Orders export”)Set wsSheet2 = ThisWorkbook.Sheets(“Sheet2”)Set wsSheet3 = ThisWorkbook.Sheets(“Sheet3”)’ Find the row with UBS Switzerland AG in the “Export Order List” sheetlastRow = wsExport.Cells(wsExport.Rows.Count, “B”).End(xlUp).RowfoundRow = 0For i = 1 To lastRowIf wsExport.Cells(i, 2).Value = investorName ThenfoundRow = iExit ForEnd IfNext i’ If the row is foundIf foundRow <> 0 Then’ Delete the found rowwsExport.Rows(foundRow).Delete’ Define new rows to insertDim newRow1 As RangeDim newRow2 As RangeSet newRow1 = wsSheet2.Rows(2) ‘ assuming data is in row 2Set newRow2 = wsSheet3.Rows(2) ‘ assuming data is in row 2′ Insert rows from “Sheet2” and “Sheet3” into “Export Order List”wsExport.Rows(foundRow).Insert Shift:=xlDownwsExport.Rows(foundRow).Insert Shift:=xlDown’ Copy data from “Sheet2” and “Sheet3” to “Export Order List”newRow1.Copy Destination:=wsExport.Rows(foundRow)newRow2.Copy Destination:=wsExport.Rows(foundRow + 1)End IfEnd Sub  Read More

​

Hi all,

We’ve set up a HVE account, and set up a Conditional Access Policy targeting this account to block sign-in to all cloud apps for any location except for the excluded IP address ranges.

A couple of problems:

1. I can still authenticate and send from an IP address not in the excluded range.

2. I don’t see any sign-in logs on Entra ID under this account.

Has anyone been successful securing the HVE account with conditional access please?

I’ve tested with a physical scanner and also ‘Send-MailMessage’ using powershell – none of the authentications are logged in Entra ID.

​Hi all, We’ve set up a HVE account, and set up a Conditional Access Policy targeting this account to block sign-in to all cloud apps for any location except for the excluded IP address ranges.A couple of problems:1. I can still authenticate and send from an IP address not in the excluded range.2. I don’t see any sign-in logs on Entra ID under this account. Has anyone been successful securing the HVE account with conditional access please? I’ve tested with a physical scanner and also ‘Send-MailMessage’ using powershell – none of the authentications are logged in Entra ID.  Read More

​

I’ve been following this documentation for creating emergency users:

https://learn.microsoft.com/en-us/entra/identity/role-based-access-control/security-emergency-access#monitor-sign-in-and-audit-logs

However, I’m unable to get any results when I’m creating and testing the alert rule.

What am I missing?

​I’ve been following this documentation for creating emergency users:https://learn.microsoft.com/en-us/entra/identity/role-based-access-control/security-emergency-access#monitor-sign-in-and-audit-logs However, I’m unable to get any results when I’m creating and testing the alert rule. What am I missing?  Read More

​

Navi has customer support phone number 09241.484-599 -: office Hours: Mon – Sat 9: 00 a.m. to 7:00 p.m. ( Navi Loans remains closed on Sundays and ever 2nd and 4th Saturday) that you can call to speak with representative. 

​Navi has customer support phone number 09241.484-599 -: office Hours: Mon – Sat 9: 00 a.m. to 7:00 p.m. ( Navi Loans remains closed on Sundays and ever 2nd and 4th Saturday) that you can call to speak with representative.   Read More

​

I use Azure Resource Graph to export data, for example:

tag
1-08

To prevent auto-convert, so I add a single quote to every rows:

tag
‘1-08

Then I download the data as csv, and save as xlsx.

If I want to hide leading single quote, I have to double click the single cell. But there are many many cells in file, how I can hide for them?

​I use Azure Resource Graph to export data, for example:   tag
1-08   To prevent auto-convert, so I add a single quote to every rows:   tag
‘1-08   Then I download the data as csv, and save as xlsx. If I want to hide leading single quote, I have to double click the single cell. But there are many many cells in file, how I can hide for them?   Read More

​

Hi guys.
Not sure what forums to put this in.
I’m about to build some new PC’s, they will have new system drives but I plan to put several of the (hdd/ssd) drives in my existing PC’s into them.

There’s always the ownership and permssions hassles. Remove this, add that, apply to all or just this folder, etc etc. One of the drives has several user folders on it, docs, pictures, music, and such so that that stuff won’t get lost if if windows has an anurism.

I can figure it all out but is there a written tutorial on doing this already?

​Hi guys.Not sure what forums to put this in.I’m about to build some new PC’s, they will have new system drives but I plan to put several of the (hdd/ssd) drives in my existing PC’s into them.There’s always the ownership and permssions hassles. Remove this, add that, apply to all or just this folder, etc etc. One of the drives has several user folders on it, docs, pictures, music, and such so that that stuff won’t get lost if if windows has an anurism.I can figure it all out but is there a written tutorial on doing this already?  Read More

​

This morning I was trying to migrate an older Window 10 Pro computer to a new Windows 11 Pro computer, one thing I almost always do is to backup the C:Users<Name>appdatalocal and .roaming Mozilla profiles to then copy into the new Mozilla profile on the new computer. No matter what I tried every directory and file copied as a copy and would not overwrite the existing files in the profile directories no matter what I did.

First both Explorer windows were run as Administrator, Google turned up a file explorer option called “Hide folder merge conflicts” which I unchecks but nothing I tried allowed me to overwrite the new profile files with the old profile files. And both versions of Firefox were the exact same version.

How can I overcome this problem?

​This morning I was trying to migrate an older Window 10 Pro computer to a new Windows 11 Pro computer, one thing I almost always do is to backup the C:Users<Name>appdatalocal and .roaming Mozilla profiles to then copy into the new Mozilla profile on the new computer. No matter what I tried every directory and file copied as a copy and would not overwrite the existing files in the profile directories no matter what I did.First both Explorer windows were run as Administrator, Google turned up a file explorer option called “Hide folder merge conflicts” which I unchecks but nothing I tried allowed me to overwrite the new profile files with the old profile files. And both versions of Firefox were the exact same version.How can I overcome this problem?  Read More

​