Sort Excel Table without moving Total Row

Help Activities
,
1

buenos dias, necesito ordenar la columna VENCIDOS, de mayor a menor, pero necesito que la fila total quede completamente quieta, ya que es el total de todo.
logre ordenar la columna, pero no puedo hacer aun el que la fila totales quede fija, pobre ingresando sort range el nombre de la tabla, pero aun asi nada, necesito su ayuda!

The image displays a detailed financial report with multiple columns including client names, various timeframe categories, overdue amounts, and total values summing to 5,177,103,239. (Subtitulado por IA)
The image displays a detailed financial report with multiple columns including client names, various timeframe categories, overdue amounts, and total values summing to 5,177,103,239. (Subtitulado por IA)690×220 39.6 KB

2

@mively
Did you used Sort range activity in modern excel activities

3

The search results pane displays various "sort" activities categorized under Recent, Installed, Classic, and Available sections in an application. (Subtitulado por IA)
The search results pane displays various "sort" activities categorized under Recent, Installed, Classic, and Available sections in an application. (Subtitulado por IA)297×441 9.12 KB

4

Use first sort range activity that should surrounded by use excel activity.

1.take excel process scope
2.use excel activity
3.use sort range activity

5

The image shows an automation script configured to sort an Excel table by the "VENCIDOS" column in descending order. (Subtitulado por IA)
The image shows an automation script configured to sort an Excel table by the "VENCIDOS" column in descending order. (Subtitulado por IA)626×712 18.2 KB

6

Hi @mively

Can you try this

This image depicts an automated sequence of actions in an Excel workflow including copying data between sheets, finding row indexes, displaying a message box, deleting specific rows, sorting data, and performing another data copy. (Captioned by AI)
This image depicts an automated sequence of actions in an Excel workflow including copying data between sheets, finding row indexes, displaying a message box, deleting specific rows, sorting data, and performing another data copy. (Captioned by AI)634×1995 81.3 KB

Input:

A spreadsheet displays employee IDs, names, and their respective salaries, along with the total salary amount at the bottom. (Captioned by AI)
A spreadsheet displays employee IDs, names, and their respective salaries, along with the total salary amount at the bottom. (Captioned by AI)700×391 6.43 KB

Output:

This image shows a spreadsheet listing employee IDs, names, salaries, and the total salary amount. (Captioned by AI)
This image shows a spreadsheet listing employee IDs, names, salaries, and the total salary amount. (Captioned by AI)619×430 6.39 KB

Sequence.xaml (13.7 KB)

Regards,

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.