Copy data on excel from one format on a worksheet to another format on a different worksheet

(1) Share

Report

Posted on by RP-25071608-0

I have a task that involves me using power automate for desktop to run through and create a flow that transforms data from the format in the first picture on the worksheet 30d-Prices to the second photo, in the worksheet MarketData-csv. The data currently in the second photo is me copy pasting by hand, and I would like to set up power automate to do it by itself. Is it possible for me to make it recognize when a new index starts, and make it go through the same function for each index? (the index is the top left data point among the highlighted values). I want to make it dynamic by row and column, so it ends when it finds an empty cell, it stops and ideally it could go to the next one. It is completely fine if I have to repeat per index, however.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

mathiaskjeldsen 224 on at

Like (1)

Report
Copy link

Link copied!

Hey

Excel automation is quite well supported in Power Automate Desktop. There are shortcut keys for almost everything you could imagine, and you can use the actions First Free Row to find the first empty row (similar thing exists for column). You can also use this action to find the latest index and store that in a Variable, and then use that as reference for when you want the formatting to start again (when the index in the variable isn't the same as the index on the new last row).

The pictures are a bit small, so can't fully see the content of it, but hope the above makes sense? Otherwise let me know.

If you are interested, these two clips might help you get sorted:

- Automate Excel finance tasks with Power Automate Desktop

- Automate your Excel tasks by using Power Automate Desktop

Best regards
Mathias Kjeldsen

---

Connect with me on social platforms by using the links below.

YouTube: https://www.youtube.com/@matkjeldsen

LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/

Was this reply helpful? Yes No
RP-25071608-0 4 on at

Like (0)

Report
Copy link

Link copied!

@mathiaskjeldsen Thank you very much, your response was definitely helpful, but I am a little unsure of how to use the index stored as a variable as a reference to go through the process. I did use use the first free row, and get empty row actions to set it up. Right now I can do it all dynamically by column, but I have to set parameters for rows, since I have to outline when a new index starts anyway, so I just write down those limits. On a slightly separate note, the way I have the write function set up, it loops to read the values from one worksheet, and writes it into the next free line onto another worksheet. This means that it does not rewrite the values, and if I have to rerun the task because the original data changed, I would have to delete all of the previous outputs and rerun the whole thing.

Was this reply helpful? Yes No