Menu:
Row Referencing
Sometimes in data manipulation you are dealing with many rows with inconsistent data spread across columns and rows.
There may be some rows, that you want to use the replace function. Some rows to delete, some rows to add a prefix. A part of a column to split etc..
To help with this, usually people sort the data, to bring together a certain values, or text together. They then change the data, but can't bring it back to the original order.
To overcome this you can reference your rows.
Let's say for example you have the below spreadsheet and you want to delete all monthly balances.
You can reference each row as per below:
Sort by column E
Delete rows 1 to 3, because they contain the monthly balances.
Sort by Column A
We now get the result, where we return to the original structure, only with all the monthly balance rows deleted.
And you didn't need to use a macro!!