ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I add a column on 3 worksheets. and get 1 total (https://www.excelbanter.com/excel-programming/454258-how-do-i-add-column-3-worksheets-get-1-total.html)

shrek March 27th 19 07:10 PM

How do I add a column on 3 worksheets. and get 1 total
 
1 Attachment(s)
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,


All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com