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: 39
Default subtotals on every user - newbie help required

I have an excel spreadsheet showing all my staff and what they output last
week. Numerous staff work in more than one location and therefore when
compiled there are several lines for them with about 30 columns of totals for
each output type.

I am looking for a macro to sort the combined sheet into alphabetical order,
delete any blank lines or ones with '0' then replace any users with more than
one record with just one total row.

 
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
Newbie question : Help required on recalculation The Narcissist Excel Programming 1 December 5th 08 04:51 AM
User Input Required axissm Excel Worksheet Functions 0 December 5th 06 01:45 PM
Newbie - macro help required urgently! kd Excel Programming 5 November 28th 04 04:35 PM
Newbie formula help required pls Luke[_3_] Excel Programming 2 June 23rd 04 08:58 PM
Newbie Excel User Needs Help! Piano_Man Excel Programming 2 April 15th 04 06:11 AM


All times are GMT +1. The time now is 07: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"