G
Guest
Hello!
Need help putting my idea into actual motion. I have a spreadsheet;
a) Column A is a list of names
b) Columns B, D, F, (skipping a letter each time) etc are figures for
different months (Dec-Jan) for the customers in column A
c) Columns C, E, G (again skipping a column letter) etc are the difference
between each month, i.e Jan-Dec, Feb-Jan, March-Feb etc.
I need the ability to click on one of the customers names in column A, which
would then bring up specific information on that customer - e.g. total
figures for that year (B+D+F etc) and total difference (C+E+G etc).
How could I do this?
Thanks x 1000!
Need help putting my idea into actual motion. I have a spreadsheet;
a) Column A is a list of names
b) Columns B, D, F, (skipping a letter each time) etc are figures for
different months (Dec-Jan) for the customers in column A
c) Columns C, E, G (again skipping a column letter) etc are the difference
between each month, i.e Jan-Dec, Feb-Jan, March-Feb etc.
I need the ability to click on one of the customers names in column A, which
would then bring up specific information on that customer - e.g. total
figures for that year (B+D+F etc) and total difference (C+E+G etc).
How could I do this?
Thanks x 1000!