subtotals on every user - newbie help required

  • Thread starter Thread starter fishy
  • Start date Start date
F

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.
 
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
 
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 -
Click to expand...


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
 
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
 
Per,

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

Richard
 
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
 
Back
Top