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