Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110872
| Path | csiph.com!goblin3!goblin.stu.neva.ru!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail |
|---|---|
| NNTP-Posting-Date | Wed, 27 Mar 2019 14:49:01 -0500 |
| From | shrek <shrek.16e18928@excelbanter.com> |
| Newsgroups | microsoft.public.excel.programming |
| Subject | How do I add a column on 3 worksheets. and get 1 total |
| Date | Wed, 27 Mar 2019 19:10:02 +0000 |
| Message-ID | <shrek.16e18928@excelbanter.com> (permalink) |
| Organization | ExcelBanter.com |
| User-Agent | |
| X-Newsreader | |
| X-Originating-IP | |
| Lines | 22 |
| X-Usenet-Provider | http://www.giganews.com |
| X-Trace | sv3-XPIgYytvR2CbabgiSgYYQ5eiXrx/id62ZmTK4HhwKLOgFfOdNOIL6A4KyDvO7ymrTc8ZjSfV39CezbJ!AWuNt3LczMQBJ7w0mKpD53+3rK8G6F7Cg1keIV855VmABjENfXf1j396TaX0Q0RUzAndjtyJbMqB!fAhpuQ== |
| X-Complaints-To | abuse@newsgroupbanter.com |
| X-Abuse-and-DMCA-Info | Please be sure to forward a copy of ALL headers |
| X-Abuse-and-DMCA-Info | Otherwise we will be unable to process your complaint properly |
| X-Postfilter | 1.3.40 |
| X-Original-Lines | 7 |
| X-Original-Bytes | 1653 |
| Xref | csiph.com microsoft.public.excel.programming:110872 |
Show key headers only | 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
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