Tag Archives: microsoft
Azure SQL Auditing
I am trying to fill some gaps in my understanding of auditing for Azure SQL
1) Why enable server auditing? I see no value proposition (Azure SQL)
2) when I enable database auditing does it automatically start auditing everything?
3) If 2 is a yes, can I create an audit specification to audit only select tables before enabling to avoid log ingestion which I don’t require?
4) does enabling audit logging for a database automatically start filling logs or does that merely create the connection to the storage
Thanks for any answers
Peter
I am trying to fill some gaps in my understanding of auditing for Azure SQL1) Why enable server auditing? I see no value proposition (Azure SQL)2) when I enable database auditing does it automatically start auditing everything?3) If 2 is a yes, can I create an audit specification to audit only select tables before enabling to avoid log ingestion which I don’t require?4) does enabling audit logging for a database automatically start filling logs or does that merely create the connection to the storage Thanks for any answers Peter Read More
pivot table date formatting not working
I want my pivot table to show the date format that exists in my source data (mm/dd/yyyy). The pivot table is automatically grouping the date into Year and Quarter, and after deleting these from the sidebar field list, the Date Field only shows the month (mm); refuses to allow formatting as desired. Does anyone know if this known ms excel pivot table problem was ever solved?
I want my pivot table to show the date format that exists in my source data (mm/dd/yyyy). The pivot table is automatically grouping the date into Year and Quarter, and after deleting these from the sidebar field list, the Date Field only shows the month (mm); refuses to allow formatting as desired. Does anyone know if this known ms excel pivot table problem was ever solved? Read More
Problem 2fa authenticator
“Hello, I am the Microsoft 365 administrator. I have encountered a problem: I changed my phone and forgot to enable the 2FA feature in the Authenticator on the new phone. Now, I can’t access my admin page. Is there a solution to this? Please help me.”
“Hello, I am the Microsoft 365 administrator. I have encountered a problem: I changed my phone and forgot to enable the 2FA feature in the Authenticator on the new phone. Now, I can’t access my admin page. Is there a solution to this? Please help me.” Read More
I cannot receive external emails after migrating from Exchange Server 2013 to 2019.
Hello everyone,
I just followed the step-by-step guide from the following link: Migrating from Exchange 2013 to Exchange 2019 – A Step-by-Step Guide to migrate my Exchange 2013 server to the 2019 version. I completed all the steps mentioned, including creating the connectors, databases, etc. Currently, I have both servers coexisting.
I used a test mailbox, which I migrated to one of the databases on the new 2019 server. The problem I’m encountering is that when sending an email from this mailbox to outside the organization, the emails are received. However, when I reply to that email from outside, the replies are not received in the Exchange 2019 mailbox.
I used the Microsoft Remote Connectivity Analyzer tool, and it didn’t show any errors. When I check the queue on the 2013 server, I can see that all the emails sent from outside are in it. The following error is indicated:
Identity: UHPEX2013Unreachable309869005505088
Subject: RE: Test
Internet Message ID: <email address removed for privacy reasons>
From Address: email address removed for privacy reasons
Status: Ready
Size (KB): 413
Message Source Name: SMTP:Default UHPEX2013
Source IP: 200.123.132.100
SCL: 0
Date Received: 23/05/2024 02:26:42 PM
Expiration Time: 25/05/2024 02:26:42 PM
Last Error: There is currently no route to the mailbox database.
Queue ID: UHPEX2013Unreachable
Recipients: email address removed for privacy reasons;2;3;There is currently no route to the mailbox database.;2;ExternosUHP2EX2019;0.
Could you please help me resolve the issue without causing impact or disruption to my productive 2013 server?
Hello everyone,I just followed the step-by-step guide from the following link: Migrating from Exchange 2013 to Exchange 2019 – A Step-by-Step Guide to migrate my Exchange 2013 server to the 2019 version. I completed all the steps mentioned, including creating the connectors, databases, etc. Currently, I have both servers coexisting.I used a test mailbox, which I migrated to one of the databases on the new 2019 server. The problem I’m encountering is that when sending an email from this mailbox to outside the organization, the emails are received. However, when I reply to that email from outside, the replies are not received in the Exchange 2019 mailbox.I used the Microsoft Remote Connectivity Analyzer tool, and it didn’t show any errors. When I check the queue on the 2013 server, I can see that all the emails sent from outside are in it. The following error is indicated: Identity: UHPEX2013Unreachable309869005505088
Subject: RE: Test
Internet Message ID: <email address removed for privacy reasons>
From Address: email address removed for privacy reasons
Status: Ready
Size (KB): 413
Message Source Name: SMTP:Default UHPEX2013
Source IP: 200.123.132.100
SCL: 0
Date Received: 23/05/2024 02:26:42 PM
Expiration Time: 25/05/2024 02:26:42 PM
Last Error: There is currently no route to the mailbox database.
Queue ID: UHPEX2013Unreachable
Recipients: email address removed for privacy reasons;2;3;There is currently no route to the mailbox database.;2;ExternosUHP2EX2019;0. Could you please help me resolve the issue without causing impact or disruption to my productive 2013 server? Read More
New skilling snack: Windows security for developers
Developers! Get this week’s collection of valuable tricks and tools to help you safeguard your code and protect your users from the worst threats the internet has to offer. In under an hour, read through the many resources on VBS, passkeys, Zero Trust, MSIX Packaging Tool, and more! There’s also a quick link to bookmark any of your favorite on demand recordings from Microsoft Build. Stay three steps ahead in the race against malware at Skilling snack: Windows security for developers.
Unfamiliar with Windows skilling snacks?
There is a sea of technical information out there, so here’s a new way to dive in without getting overwhelmed!
Every two weeks, there will be a handpicked snack-size selection of essential articles, demos, deep dives, and learning modules on a specific topic—all of which can be consumed in less than two hours. Skill up over a long lunch break, the weekend, or a slow day at the office! Break the routine with hands-off video or use your browser to turn an article into a read-aloud experience while you get up and stretch, take a walk, or multitask.
To catch up and view the whole menu, see Windows skilling snacks: bite-sized learning for IT pros.
Bon appétit!
Developers! Get this week’s collection of valuable tricks and tools to help you safeguard your code and protect your users from the worst threats the internet has to offer. In under an hour, read through the many resources on VBS, passkeys, Zero Trust, MSIX Packaging Tool, and more! There’s also a quick link to bookmark any of your favorite on demand recordings from Microsoft Build. Stay three steps ahead in the race against malware at Skilling snack: Windows security for developers.
Unfamiliar with Windows skilling snacks?
There is a sea of technical information out there, so here’s a new way to dive in without getting overwhelmed!
Every two weeks, there will be a handpicked snack-size selection of essential articles, demos, deep dives, and learning modules on a specific topic—all of which can be consumed in less than two hours. Skill up over a long lunch break, the weekend, or a slow day at the office! Break the routine with hands-off video or use your browser to turn an article into a read-aloud experience while you get up and stretch, take a walk, or multitask.
To catch up and view the whole menu, see Windows skilling snacks: bite-sized learning for IT pros.
Bon appétit! Read More
How Do I Fix QuickBooks Error 12157 When Payroll Update Failed
QuickBooks is having trouble QuickBooks Error 12157 When Trying to Payroll Update. Each attempt ends in failure with an error message. Has anyone else experienced this problem? What can I do to fix it? Any advice would be greatly appreciated!
QuickBooks is having trouble QuickBooks Error 12157 When Trying to Payroll Update. Each attempt ends in failure with an error message. Has anyone else experienced this problem? What can I do to fix it? Any advice would be greatly appreciated! Read More
What to Do When QuickBooks Connection Has Been Lost Windows 10
I’m having trouble QuickBooks Connection Has Been Lost Windows 10, I encounter errors or the process doesn’t seem to work. How can I resolve this issue and regain access to my QuickBooks account?
I’m having trouble QuickBooks Connection Has Been Lost Windows 10, I encounter errors or the process doesn’t seem to work. How can I resolve this issue and regain access to my QuickBooks account? Read More
Deployed Teams app cannot find any installation, but I’ve installed it via “Upload custom app”
I’ve followed the Build notification bot with JavaScript docs to create a Team App that sends a “Hello World” message to an specific user (email). I’ve validated that the app is working locally, and that I can receive messages if I install the app locally using Teams Toolkit.
However, after deploying the app to the cloud and installing it using the “Upload custom app dialog”, I’m not able to receive messages. I can see in the Web App Monitoring in Azure that request are coming to the cloud service, however, it seems it cannot find any installations, and hence, any members to send the message to.
I made sure that the manifest I’m using to install the app is the same one I used to deploy the app to the cloud. How can I troubleshoot this?
I’ve followed the Build notification bot with JavaScript docs to create a Team App that sends a “Hello World” message to an specific user (email). I’ve validated that the app is working locally, and that I can receive messages if I install the app locally using Teams Toolkit. However, after deploying the app to the cloud and installing it using the “Upload custom app dialog”, I’m not able to receive messages. I can see in the Web App Monitoring in Azure that request are coming to the cloud service, however, it seems it cannot find any installations, and hence, any members to send the message to. I made sure that the manifest I’m using to install the app is the same one I used to deploy the app to the cloud. How can I troubleshoot this? Read More
Business Process Tracking Preview Update
Background
Last November, we announced the Public Preview of the Integration Environment and Business Process Tracking. Since this time, we have been engaged with many customers learning about their use cases and listening to their feedback. Based upon this feedback, we have made some investments that we are going to be announcing during the week of June 10th, 2024. Look for updates on this blog and at the Integrate 2024 event.
In preparation for this new release, we want to provide you with advanced notice of a breaking change that will take place. Based upon customer feedback, we are implementing support for business process stage statuses. This will allow customers to define success and failure milestones that give you more control over reporting the outcome of your business process. This new capability requires a breaking change to our existing schema which will impact existing business processes.
To avoid runtime tracking errors, the following steps are required. Please note that these runtime tracking errors will not impact any workflow runtime executions.
Call to action
The new schema is not compatible with the older schema, as a result, we are recommending the following actions take place by June 3rd, 2024:
Document what your business process is currently doing by taking notes, screenshots, etc.
Undeploy any existing business processes. This will prevent future runtime tracking errors from occurring as a result of an old schema.
Undeploying can be achieved by clicking on the … menu on a deployed business process and then selecting the Undeploy label.
By undeploying your business process, the related tracking profile(s) will be removed from associated Logic Apps and related configuration values will be removed from Environment Variables found within impacted Logic Apps.
Detecting invalid tracking profile schemas
In the event, that existing business processes are not undeployed before June 3rd, customers can expect to find the following error in the Notifications panel found in the Logic Apps Overview page: The tracking profile schema isn’t supported.
Additional Support
If you require additional support after June 3rd, please reach out to customer support where a support engineer can further assist in removing the business process.
Microsoft Tech Community – Latest Blogs –Read More
Why am I getting QBWC1085 error in QuickBooks Web Connector?
I’m encountering an issue with QBWC1085 error in QuickBooks Web Connector. Every time I try, it gives me an error message. What could be causing this problem, and how can I fix it?
I’m encountering an issue with QBWC1085 error in QuickBooks Web Connector. Every time I try, it gives me an error message. What could be causing this problem, and how can I fix it? Read More
How can I resolve a QuickBooks Error 12057 When Incorrect Internet Explorer settings
I’m having trouble QuickBooks Error 12057 Every time , I encounter errors or the process doesn’t seem to work. How can I resolve this issue and regain access to my QuickBooks account?
I’m having trouble QuickBooks Error 12057 Every time , I encounter errors or the process doesn’t seem to work. How can I resolve this issue and regain access to my QuickBooks account? Read More
What to Do When Unable to update QB Premier (2014 Edition): Error 15227
I’m experiencing an issue with QuickBooks Error 15227. I’ve tried restarting the software and my computer, but the problem persists. How can I fix this and ensure that multi-user access works properly?
I’m experiencing an issue with QuickBooks Error 15227. I’ve tried restarting the software and my computer, but the problem persists. How can I fix this and ensure that multi-user access works properly? Read More
Sensitivity labels for images not carried over to SharePoint
Hi there,
I have a customer using the Purview Information Protection client to apply sensitivity labels locally in Windows before uploading files into SharePoint. The Office files are retaining the sensitivity labels but images (JPGs PNGs, etc.) and PDFs are not. Is this a hard limitation or is there a way to retain (or activate) the sensitivity labels on images in SharePoint/OneDrive?
Thanks,
Alan
Hi there, I have a customer using the Purview Information Protection client to apply sensitivity labels locally in Windows before uploading files into SharePoint. The Office files are retaining the sensitivity labels but images (JPGs PNGs, etc.) and PDFs are not. Is this a hard limitation or is there a way to retain (or activate) the sensitivity labels on images in SharePoint/OneDrive? Thanks,Alan Read More
Automated end-user feedback response is now GA
We are excited to announce that the automated end-user feedback response feature is now GA! The user submission automatic feedback response capability in Microsoft Defender for Office 365 enables organizations to automatically respond to end user submissions of phish based on the verdict from the automated investigation.
This feature saves SecOps time by converting the process of sending manual responses back to end users on reported messages to be automated. This layers additional value to the automated investigation and response (AIR) feature for SecOps teams and also helps encourage end users to contribute to the security posture of the organization by providing acknowledgment and feedback on those user reports of phish automatically.
Configuration
The ability to automatically respond to end user submissions of phish is configurable and can be turned on from the user reported settings page (Settings > Email & collaboration > User reported settings) and configured to send based on the AIR verdict.
User submission automatic feedback response configuration found in settings > email & collaboration > user reported settings > automatically email users the results of the investigation:
Phishing or Malware: Selecting this box indicates that the organization would like end users to receive an automatic response email on email submissions of phish when the associated user submission investigation identifies a threat of normal phish, high confidence phish or malware.
Spam: Selecting this box indicates that the organization would like end users to receive an automatic response email on email submissions of phish when the associated user submission investigation shows the threat of spam.
No threats found: Selecting this box indicates that the organization would like end users to receive an automatic response email on email submissions of phish when the associated user submission investigation finds no threats.
Response Timing
The automated end user feedback response is sent at the conclusion of the investigation when the investigation hits a final status. This means investigations in pending approval status must be approved before the response will be sent.
Email Template
The email that is sent to the end users utilizes the same email template as the organization’s Mark & Notify email template and allows the customization of the email body for the respective threats of Phishing, Junk and No threats found (corresponding to the Phishing or Malware, Spam, and No threats found settings above respectively). Learn more about Mark & Notify on this page: Admin review for reported messages – Office 365 | Microsoft Learn.
User submission automatic feedback response configuration of email message using customize admin review email notification:
Function
Once enabled, Microsoft Defender for Office 365 will automatically respond to end user submissions based on the investigation verdict and the configured settings. For example, if an organization has enabled the user feedback response for emails with no threats found, if a user reported a message as phish it would trigger automated investigation and response (AIR) and begin an investigation on the user reported message. If that investigation concludes with no threats found and the organization had enabled the automatic feedback response for no threats found, then the end user who submitted the message would receive an email stating there were no threats found on the submitted message. The message would resemble the below, but the body of the message and footers would contain what the organization has put in for admin review for reported messages for the no threats found option.
Sample user submission automatic feedback response for no threats found:
If an organization has enabled the user feedback response for emails with Phishing or Malware, if a user reported a message as phish it would begin an investigation on the user reported message. If that investigation discovers high confidence phish or malware the investigation would be looking for these to be remediated either with the approval of recommend actions, shown as pending actions in the investigation, incident and action center, or remediation through other means such as explorer. Once the high confidence phish or malware threats found in the investigation have been remediated, the investigation would close as “Remediated” or “Partially Remediated” at which point the user submission feedback email would automatically be sent to the user who reported the message. If only a threat of normal phish was identified for a message, the investigation would not produce pending actions however the end user would still receive a response indicating the message was phish. The message would resemble the below, but the body of the message and footers would contain what the organization has put in for admin review for reported messages for the phishing option.
Sample user submission automatic feedback response for high confidence phish or malware:
Note: The response is not sent to end users until any discovered high confidence phish or malware threats are remediated, meaning responses will not be sent when the investigation is pending action. The investigation must reach “Remediated” or “Partially Remediated” status in order for the response to be triggered.
Display
When users receive an automatic feedback response, this will be reflected in the submission queue as “Marked as” similar to other submissions that may have manually received a response.
User submission automatic feedback response reflected on submissions queue marked as:
Learn More
To learn more about the automated end user feedback response feature visit Automatic user notifications for user reported phishing results in AIR – Microsoft Defender for Office 365 | Microsoft Learn.
To learn more about submissions and investigations in MDO please visit the following pages:
Automated investigation and response in Microsoft Defender for Office 365 – Office 365 | Microsoft Learn
View the results of an automated investigation in Microsoft 365 – Office 365 | Microsoft Learn
Admin review for reported messages – Office 365 | Microsoft Learn
How automated investigation and response works in Microsoft Defender for Office 365 – Office 365 | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
ADF Dataflows recently started occasionally reporting SubStatus, instead of RunStatus
In the last week or so, we have started to have pipelines fail because our dataflows have, occasionally, started reporting SubStatus instead of RunStatus in the output. Its not every time, nor can i see a pattern in e.g. the time delay between dataflow completing and the set variable task starting.
Has anyone else seen this before, and got a solution?
In the last week or so, we have started to have pipelines fail because our dataflows have, occasionally, started reporting SubStatus instead of RunStatus in the output. Its not every time, nor can i see a pattern in e.g. the time delay between dataflow completing and the set variable task starting. Has anyone else seen this before, and got a solution? Read More
Rotate Word Template Mail Merge Fields
I have been asked to create a Word template that is to be used to imprint addresses on envelopes.
I am using Power Automate to collect the data from Excel, insert the data into the Word template mail merge labels, and merge the multiple pages into a single word document.
The template fields currently look as below.
I am trying to figure out if the Labels can be rotated in the template so that they print out as such -.
I have been asked to create a Word template that is to be used to imprint addresses on envelopes.I am using Power Automate to collect the data from Excel, insert the data into the Word template mail merge labels, and merge the multiple pages into a single word document.The template fields currently look as below. I am trying to figure out if the Labels can be rotated in the template so that they print out as such -. Read More
Microsoft Partner FY25 GTM Launch Event – July 22, 2024 – Registration Now Open!
We’re thrilled to announce that registration is open for the Microsoft Partner FY25 GTM Launch Event!
Join us on July 22, 2024, to hear about the go-to-market (GTM) priorities and initiatives Microsoft Modern Work and Business Applications have planned for FY25. We’ll show you how you can play a critical role, as trusted advisors and service and solution providers, in delivering the right AI-powered tools and technologies to empower every organization to boost productivity, transform work, and open a new world of possibilities.
This year’s event features three tracks for partners.
· Build New Value with Business Applications Practices is for partners that provide Business Applications services and solutions to Enterprise and Corporate customers focused on Dynamics 365 and Power Platform.
· Cloud Solution Provider (CSP) Partner-Led GTM will show our CSP partners how to use the power of AI to build your Modern Work and Business Applications Copilot practice.
· Co-Sell with Microsoft to Managed Customers is for partners that work alongside our Microsoft sales teams to sell Microsoft 365-related licenses, services, and solutions to Enterprise and SMC-Corporate customers.
Register today to reserve your spot– and to get details ahead of the event about the sessions and topics that will be covered. Unable to attend the live event? Registering will help ensure you get notified automatically when session content is available on demand.
—
Advanced Support for Partners (ASfP) and Premier Support for Partners (PSfP) are paid partner offerings at Microsoft that provide unmatched value through a wide range of Partner benefits including account management, technical cloud enablement consultations, and an elevated technical support experience across the Microsoft Cloud (Azure, Microsoft 365, Dynamics 365, Power Platform).
Partners in ASfP have higher Microsoft AI Cloud Partner Program Capability Scores, attain more Solutions Partner designations, and see uplifts across Azure, M365, and D365. View the data and learn more on the new ASfP Impact slide below.
Please review these resources to learn more and consider booking a meeting to speak directly with our teams for a better understanding of the value-added benefits of ASfP and PSfP.
Book a meeting with an ASfP Evangelist
Visit the ASfP Website
Download the ASfP Fact Sheet
View the ASfP Impact Slide
Stop by the ASfP Partner Community
Book a meeting with a PSfP Specialist
We’re thrilled to announce that registration is open for the Microsoft Partner FY25 GTM Launch Event!
Join us on July 22, 2024, to hear about the go-to-market (GTM) priorities and initiatives Microsoft Modern Work and Business Applications have planned for FY25. We’ll show you how you can play a critical role, as trusted advisors and service and solution providers, in delivering the right AI-powered tools and technologies to empower every organization to boost productivity, transform work, and open a new world of possibilities.
This year’s event features three tracks for partners.
· Build New Value with Business Applications Practices is for partners that provide Business Applications services and solutions to Enterprise and Corporate customers focused on Dynamics 365 and Power Platform.
· Cloud Solution Provider (CSP) Partner-Led GTM will show our CSP partners how to use the power of AI to build your Modern Work and Business Applications Copilot practice.
· Co-Sell with Microsoft to Managed Customers is for partners that work alongside our Microsoft sales teams to sell Microsoft 365-related licenses, services, and solutions to Enterprise and SMC-Corporate customers.
Register today to reserve your spot– and to get details ahead of the event about the sessions and topics that will be covered. Unable to attend the live event? Registering will help ensure you get notified automatically when session content is available on demand.
—
Advanced Support for Partners (ASfP) and Premier Support for Partners (PSfP) are paid partner offerings at Microsoft that provide unmatched value through a wide range of Partner benefits including account management, technical cloud enablement consultations, and an elevated technical support experience across the Microsoft Cloud (Azure, Microsoft 365, Dynamics 365, Power Platform).
Partners in ASfP have higher Microsoft AI Cloud Partner Program Capability Scores, attain more Solutions Partner designations, and see uplifts across Azure, M365, and D365. View the data and learn more on the new ASfP Impact slide below.
Please review these resources to learn more and consider booking a meeting to speak directly with our teams for a better understanding of the value-added benefits of ASfP and PSfP.
Book a meeting with an ASfP Evangelist
Visit the ASfP Website
Download the ASfP Fact Sheet
View the ASfP Impact Slide
Stop by the ASfP Partner Community
Book a meeting with a PSfP Specialist
Visit the PSfP Website Read More
May 28 Virtual Event: Optimizing Business Impact through the Commercial Marketplace
Sharing a really interesting virtual event whereby GM, Marketplace FastTrack Paul Maher will be discussing the direction of Microsoft Copilot in the Microsoft Commercial Marketplace. He’ll be joined by a team of experts who will offer insights into how to deepen success across offer type and channel.
This virtual event is on May 28, 9 – 10 am PDT and I understand it’s a great time for all Microsoft partners and organizations to gain insights and share experiences in this live, interactive session.
Register here: https://msit.events.teams.microsoft.com/event/12a098f6-9e2a-40ae-b43f-321e7d2eb166@72f988bf-86f1-41af-91ab-2d7cd011db47
Hope to see you’ll there!
Sharing a really interesting virtual event whereby GM, Marketplace FastTrack Paul Maher will be discussing the direction of Microsoft Copilot in the Microsoft Commercial Marketplace. He’ll be joined by a team of experts who will offer insights into how to deepen success across offer type and channel. This virtual event is on May 28, 9 – 10 am PDT and I understand it’s a great time for all Microsoft partners and organizations to gain insights and share experiences in this live, interactive session. Register here: https://msit.events.teams.microsoft.com/event/12a098f6-9e2a-40ae-b43f-321e7d2eb166@72f988bf-86f1-41af-91ab-2d7cd011db47 Hope to see you’ll there! Read More
Where are your users? WFH or Office?
▶ Head over to Working from home report (wfh.report) and feast your eyes on the demo map showing user locations.
And, if you are an admin, you can explore the whereabouts of your real users!
▶ Head over to Working from home report (wfh.report) and feast your eyes on the demo map showing user locations.And, if you are an admin, you can explore the whereabouts of your real users! Read More
Copy filtered data from one workbook to another workbook
Need help with vba macro in the below scenario
I have data in one workbook in sheet 1(raw data)
I have to apply filter to the sheet and filter by pending from status column.
Need to copy entire data except the header and paste in another existing workbook_2 in sheet 1,(report). Remove the filter.
Now again filter the data by completed status along with T-2 Working days from end date column.(Raw data).
Copy entire data, except the header and paste in (report) below the existing data.
Remove both the filters.
Again filter the data by exception in status column & copy entire data except the header and paste in report below the existing data.
Now from report sheet of workbook_2, have to copy column F,G,H,J and have to paste it in sheet 1 of Workbook_3 in column B only starting from row 4.
Need help with vba macro in the below scenario I have data in one workbook in sheet 1(raw data) I have to apply filter to the sheet and filter by pending from status column.Need to copy entire data except the header and paste in another existing workbook_2 in sheet 1,(report). Remove the filter.Now again filter the data by completed status along with T-2 Working days from end date column.(Raw data). Copy entire data, except the header and paste in (report) below the existing data.Remove both the filters.Again filter the data by exception in status column & copy entire data except the header and paste in report below the existing data. Now from report sheet of workbook_2, have to copy column F,G,H,J and have to paste it in sheet 1 of Workbook_3 in column B only starting from row 4. Read More