Excel Script to work with Power Automate that will copy Data from 1 cell in a worksheet to another cell in another worksheet based on criteria in a cell on the row.

Question

Hello:

I am new to the scripts part of Excel and Power Automate.  I need MAJOR help.

 

See HERE for the images!

 

I have 1 single Workbook with 10 different worksheets within it.  This script is focusing on just 2 of the worksheets. (They are labeled EXACTLY as typed below):

WIP Overview (Kinda like a dashboard worksheet)

WO in Progress (Main worksheet where the data is that needs to be copied)

(See Image 1)

 

WIP Overview: This worksheet is blank other than rows 1 & 2, but has columns A-F repeat 6 times under different “Priorities”.  (See Images 2 & 3.)

(To better see the column headings see images 4 & 5.)

 

NOW on WO in Progress: Information is brought over to this sheet via VBA Macros (will be asking questions at another time for converting the macros to scripts so don’t worry about those at this time) from WO to Create tab when a Value is placed in Column M (this is just an FYI part).  The information to feed (copy) to WIP Overview comes from the WO in Progress worksheet.  (See images 6 & 7 for layouts.)

 

SOOOOOO my big question on the help!

 

The lines of data in WO in Progress change consistently and the sheet usually has roughly 300 rows at any given time.  We have 6 different “Priorities” to choose from to give a work order for a customer when it is created. _(HIGH, MEDIUM, LOW, PIP/WARRANTY, INTERNAL, INSPECTION_____S)  These help us to prioritize which workorders to perform first and so on.  With the high number of rows in the WO in Progress sheet, we have created the “DASHBOARD VIEWish”  WIP Overview worksheet in order to have a way of seeing what work orders are under each priority quickly.  The “Priority” category for each work order (row) is in column E of the WO in Progress worksheet.

 

So what I need is for the script to look on EVERY row of WO in Progress under column E for the Priority category.  Then it is to take information from that row based on the priority _(HIGH, MEDIUM, LOW, PIP/WARRANTY, INTERNAL, INSPECTION_____S)  and put specific information in the correct priority area of worksheet WIP Overview.

 

For instance, Row 3 has a Priority of LOW.  The script would take the data from WO in Progress A3 and place it in WIP Overview O3 and so on.  (See image 8 compared to images 6 & 7).

 

I need this to constantly run and update as the data is updated.  Adding and deleting the data as it changes.

 

I really appreciate the help as I have been struggling with trying to write this for over a month.

 

Answer 1

Hi,

It is recommended that you post the thread to Power Automate forum:

https://community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.