Hi everyone,

I have been trying to use a lot of the examples I have found here in the
forums but am so far unable to do so. I have a spreadsheet that will almost
always be different everytime the macro runs. There will always be the same
number of coulmns A:AD but the rows will either increase or decrease in
number. Also there may be multiple blank rows in beteen rows with data. And
there may only be one column on a row that may have something in it. The
first row will be A8 and the last row will always have "Grand Totals" at the
bottom of column A but again I don't know how many rows there might be.

Thanks in advance for any help.