I hope I've explained the situation clearly enough. How do I make the connection between this desktop excel file and the one in excel online? How can I dynamically reference a specific cell in Excel Online to use in the desktop version of excel? Any and all advice is appreciated here, I'm not really sure where to start. That sheet in Excel Online would look something like this. For our example, the order number is OM00012041, so the sheet on the schedule would be named "OM00012041". Today we are announcing two new places you can use generative AI: in your apps with a next-generation control (learn more here), and in Power Automate for desktop: There is a new AI Builder action that you can use in your desktop flows called Create text with GPT, just like in cloud flows today. In the online excel sheet, someone else in my business will have already pasted the order info into a sheet named "(ORDER NUMBER)" on our production schedule in Excel Online. (please excuse the poor censoring job, sorry lol)
Once in the Settings screen, you can enable or disable ' Play completion sound '. The rest of the columns will be filled in after the form is printed, so don't worry about any of those. To access Settings (in the mobile and desktop versions), from the main (top-level) screen, select your name in the upper left corner and select Settings. When the user enters in the order number that they want, call it order OM00012345, I want the item, item description, and QTY columns to auto-populate. The form is on the desktop version of excel, and the data that it pulls is in the online worksheet. I'm trying to automate an inspection sheet for orders that my company ships out. I am working in he desktop version of Excel and I'm trying to make a dynamic reference to an online worksheet.
0 kommentar(er)
