Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110872

How do I add a column on 3 worksheets. and get 1 total

Show all headers | View raw

Hi 

I have a workbook of which has 3 sheets in it.  Each worksheet has the
same layout .

What im trying to do is to have a macro or something that when I click
on a button it puts a black line below the last entry in each worksheet
and then adds up the totals in each worksheet in column F up to the
black line and creates a total for all 3 sheets in a box. 

The attached sheet maybe explains better,


+-------------------------------------------------------------------+
|Filename: book 1.zip                                               |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1061|
+-------------------------------------------------------------------+



-- 
shrek

Back to microsoft.public.excel.programming | Previous | Next | Find similar | Unroll thread

Thread

How do I add a column on 3 worksheets. and get 1 total shrek <shrek.16e18928@excelbanter.com> - 2019-03-27 19:10 +0000

csiph-web