Hi Joey. Take a look at this site. It may help.
http://www.xldynamic.com/source/xld.LastValue.html
--
Sincerely, Michael Colvin


"Joey" wrote:

Sheet 1 Column a Row 1-5
Copy of cells to sheet two a1 put a total two rows below list a7 this time.
The next time sheet one may have row 1-10.
Now macro should put answer on a12 and total rowa 1-10.
ANy help.
New to writing macros