I receive a daily report; I need help in automating this process.
Step one: highlight the entire spread sheet
Step two: expand the columns so I can read the information
Step three: de activate highlight
Step four: go to columns N thru Z) and set the date. (Format date and time)
Step five: go to Colum (AA) format alignment. Get rid of wrapped text.
Step six: Hard part because this always changes depending on the report.
6a- I have to highlight the rows and insert tree spaces. The reason this is
difficult is because I have matching invoices that need to be grouped
together all the way down.
Step Seven: after all the spacing in the rows is in I need to copy the top
row of all matching invoices and copy it one row above where I copied it from:

On the copied row I have to use the concatenate formula all the way down the
spread sheet

Example:
Copied Row - 12345 cat dog worms
Original row- 12345 cat dog worms Also a matching invoice.
Matching invoice 12345 cat dog worms
Matching Invoice 12345 cat dog worms

Through out this sheet we have miss-matched invoices numbers we have to work
around.

Step seven: I have to use the (Sum) on column (H) then copy to (Columns I,
J, K) all the way down where I used the concatenate formula.

Step eight: go over to column (A) and wrap the text. Format, alignment,
wrap text

Step Nine: Copy and paste the wrapped text and use the (PASTE as Special)
choose values for every row where I used the concatenate and sum formulas.
Step Ten: delete all unused rows to clean it up.

Is there an easier way to do this?
Thanks in advance