Sorry, I am new to excel macros and was not sure were else to turn. I am not sure the title quite fits this but here goes.

I have a spreadsheet, in it are 6 columns
A = Name
B = Category
C = Data1
D = Data2
E = Data3
F = Data4

Here is my problem, I made a sort that sorts all this data by name, and all names are written the same so there are no problems there. There are a total of four Categories(Column B) - and then data for each category. My issue is some people have only one or two categories because they have no data for the month, so thus no category listed. For reports we need to have all four categories listed for each person.

So my question, how do I do this. If there is a category missing, when it is added all data for C through F will be "0". But how do I add this so that reports made from this data will have all for categories even if for some people they currently arent listed.

Any help would be great, I got some of the basics down, but I couldn't really find anything like this in google.

Thanks a bunch,

Jesse

Not really able to answer specifically because you do not say how data
gets from the sheet to your reports.

Also, do not see why you have a problem. Normally we use Excel
functions to summarise data. If there is no data, the total comes to
zero. If you have your reports linked to your data correctly you will
have cells for those items showing zero.

The only thing I can think of is that your report does not contain
spaces for every possible data combination, which, of course is wrong
because :-

1. A visible zero value can be important.
2. You are having to produce a variable report format instead of using
a standard (and able to be copied) worksheet setup which can be linked
to your data so that when data is replaced the report results change
too.
3. You have a check that the totals on the reports match the total of
the data.

If you need any help with setting up/linking your reports please make a
new posting with an idea of what the data consists of and how you are
summarising it. Many of us do not read postings that appear to have
been answered already.


---
Message posted from http://www.ExcelForum.com/