I want to have a worksheet for data entry, but add and display the totals on another worksheet. How?
D DNA May 11, 2005 #1 I want to have a worksheet for data entry, but add and display the totals on another worksheet. How?
D Don Guillett May 11, 2005 #2 macro to sheets("destination").range("a2:b6").value=sheets("source").range("a2:b6").v alue or in destination source!a2
macro to sheets("destination").range("a2:b6").value=sheets("source").range("a2:b6").v alue or in destination source!a2