Hello every one,
I have to run a report every monday to check on project status. the report
(file1)has two blank rows in between each project. I have a marco that
deletes blank rows. I also have a file that has my calculations in columns ac
thru columns ao. In the past i would just copy all the columns in File 1 in
to File 2. is there a way I could automate this?

Thanks

G'day Lee

Check out Ron's website, he has several examples on achieving what you are
trying to do.

http://www.rondebruin.nl/tips.htm

HTH
Mark.