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

"fishy" skrev i meddelelsen
...
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.

On Jan 25, 2:47*am, "Per Jessen" wrote:
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" skrev i ...



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.- Hide quoted text -

- 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

Per,

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

Richard

"Per Jessen" wrote:

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" skrev i meddelelsen
...
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 Richard,

If it is a larger file, try to send it as a Zip file, or try my hotmail
address:

Per

"fishy" skrev i meddelelsen
...
Per,

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

Richard

"Per Jessen" wrote:

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" skrev i meddelelsen
...
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.


.

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 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.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Resolving the ASP.NET Database Security Dilemma
http://www.eggheadcafe.com/tutorials...spnet-dat.aspx