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

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

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

Back to article view | Back to microsoft.public.excel.programming

Contents

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

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

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

[toc] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web