ExcelBanter - Totals From Another Worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Totals From Another Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/25652-totals-another-worksheet.html)

DNA

Totals From Another Worksheet

I want to have a worksheet for data entry, but add and display the totals
on another worksheet.

How?

Don Guillett

macro to
sheets("destination").range("a2:b6").value=sheets( "source").range("a2:b6").v
alue
or in destination
source!a2

--
Don Guillett
SalesAid Software

"DNA" wrote in message
lkaboutsoftware.com...
I want to have a worksheet for data entry, but add and display the totals
on another worksheet.

How?

All times are GMT +1. The time now is 10:10 PM.