LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default macro to sub total a unique cell value

Help please!! is is possible to have macro that sub total
G1:G498 and put the answer infront of a cell
that has vacation1. example if vacation1 is in A500 i
want the subtotal at B500. And the cell below vacation1
will be
sick1 and i will like to sub total H1:H498 and have the
answer in the cell in front of sick1. Example if sick1 is
in
A501 I want the subtotal at B501. I do not want to use
the cell number because it changes. only the name is
unique for each totals. And then for G498:G598 I will
like the
answer in vacation1 B600. AND so on. This project is too
long and I am not familiar with macros.
Thanks all in advance

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Wrong total but add each cell gives the correct total Steved Excel Worksheet Functions 6 January 8th 09 01:19 AM
Pivot Table Sub Total Count Unique Dates MFM Excel Worksheet Functions 2 November 14th 08 10:18 PM
Find total number of unique model numbers Brian Excel Worksheet Functions 8 September 19th 08 05:51 AM
Unique print macro question Brad Excel Discussion (Misc queries) 3 June 29th 07 10:20 PM
Can I total only a % of a number (cell) base on total of all cel Douglas Excel Discussion (Misc queries) 2 October 6th 06 09:52 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"