Relative Reference

I am trying to record a macro. I don't know anything about VBA and I am just recording my actions. I am trying to take a daily report from another program and format it into a usable Excel spreadsheet. There are some columns and many rows to delete. I take the same steps everyday and would like to automate the process. First, I remove the blank filler columns (which the other program uses to space the data), autofit the columns with data and format the text. Then, I need to eliminate the empty rows seperating each customer. This amounts to hundreds of rows. Manually, I use ctrl-end, delete the last 3 rows (unneeded data), use shift-ctrl-home to highlight all of the data, put in filters, show only blank rows, and delete those rows. However, recording the macro this way causes problems for any report longer than the original. When I record it using relative references, I get errors. If recording without relative references, when you hit ctrl-end does it record as ctrl-end (and therefore should always go to the last cell regardless of the size of the report) or does it record as the actual cell it ends up on (which would explain why my longer reports format the upper half of the report and not the bottom). Any thoughts? Any more info I need to give? Thanks!

Okay, I have replaced all of the confidential information. Before I attach it, how should I let you know the exact steps I take each day? I have a macro that works for this day, but not for reports with more transactions. Can I attach the macro as well? Thanks.