•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Which formula will help me to match SAP Work Order numbers against SAP Notification numbers?
I have a spreadsheet, where I enter SAP notification numbers from a shift log. Then each week I go to SAP and check if those notifications have been converted to work orders. So far I am exporting the SAP Work Order numbers (it also has the notification number column) in an excel sheet and then manually matching and copy/pasting the work order numbers against those notification numbers in the parent spreadsheet. Which formula can be used to make this process quicker? At present it takes me around 1 hour to "Find" the notification and then "Copy/paste" the WO. Thanks in advance
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#AI formula generation techniques
#rows.com
#formula generator
#SAP Work Order
#SAP Notification
#excel sheet