better way of tracking / summarizing data.

T

testes

here's an example of my problem.

new worksheet:
4 tabs:

tab 1 = month 1
tab 2 = month 2 (contains separate columns for month 1 data and month 2
data)
tab 3 = month 3 (contains separate columns for month 1 data, month 2
data, and month 3 data)
tab 4 = summary

each monthly tab has 3 rows, customer 1, customer 2, customer 3.
and 3 columns (for each customer) product 1, product 2, product 3. (for
each month within each monthly tab)

it is possible for the customer to change data from month 1 for any
product while in a subsequent month.

I need a summary page to be able to track the numbers for each product
line for each customer and be able to readily see any changes from
month to month.

so the summary tab might contain some sort of unique identifier for
each customer / product line and then a summary of all the months and
the "history" of product counts for each product. now I think I can
set something up using somesort of vlookup consisting of some sort of
concatenate function, but was wondering if there is a more efficient
way of presenting this summary information than that. Ideally I'd like
to all customer information contained in one row, but realize this might
make for a very wide table. any suggestions?
 
R

Roger Govier

Hi Earl

Just read your link. Very succinctly summarised and neatly presented example.

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Cell based on Date 8
Help creating a sales commission formula 3
summaries on alternative sheets 6
If Statement Error 12
copy and paste 1
help-planning 1
Sumif, unique counts, 4
Extract Database 1

Top