I know how to create a macro, but I have a question. I get a report every month that I download to a excell file. It has equipment broken down by department. I then create tables, get rid of the extra colums, group the items under the department so I can choose what I want to see, etc. I could create a macro to do this every month, but the problem is that the amount of information changes. One month I could have 100 pieces of equipment that come up under a given department, and the next month 2. Is there a wat to set up a macro so that it can compensate for this?