subtotals on every user - newbie help required

[fishy]

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.

 

[Per Jessen]

Hi

Post some sample data, along with the result you are looking for.

If desired, you can mail me a sample workbook with a description on what you
want and the result you expect.

Regards,
Per

 

[goshute]

Hi

Post some sample data, along with the result you are looking for.

If desired, you can mail me a sample workbook with a description on what you
want and the result you expect.

Regards,
Per

"fishy" <[email protected]> skrev i meddelelsen




- Show quoted text -

How about trying a Pivot Table. It will do exactly what you want. If
you need to e-mail the results, Select the pivot table then, Copy/
Paste Values.

Goshute

 

[Reno Gajo]

Have a look at www.genresoftware.com. You could use the software either as a supplement or alternative to Excel. Cheers. Reno



fishy wrote:

subtotals on every user - newbie help required
25-Jan-10

I have an excel spreadsheet showing all my staff and what they output las
week. Numerous staff work in more than one location and therefore whe
compiled there are several lines for them with about 30 columns of totals fo
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 tha
one record with just one total row.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Resolving the ASP.NET Database Security Dilemma
http://www.eggheadcafe.com/tutorial...b7-dda71223faa0/resolving-the-aspnet-dat.aspx

 

[fishy]

Per,

I have tried a couple of time to send the file but your email address comes
up as failing.

Richard

 

[Per Jessen]

Hi Richard,

If it is a larger file, try to send it as a Zip file, or try my hotmail
address: (e-mail address removed)

Per