D
Dianna999
HI,
Hope you can help me....I would like to have a cell be broken down into
multiple layers...
The spreadsheet is as follows...
A9=date
B9=comments
C9=Expense Type (Meals, Cell, or Travel)
D9=total expense
E9=Tax
F9=Total for GL entry
Once C9, D9 and E9 are entered; F9 calculates based on macros and formulas.
Now what I would like to do, is...once F9 calculates, the user to be
prompted to enter the following additional information from drop down
lists...Customer Name, % allocated and Customer Code. The results then
displayed on a adjacent worksheet
Example:
A9 - 3/18/08
B9 - none
C9 - Meals
D9 - 79.00
E9 - 3.76
F9 = 77.12
Popup box asks for additional information (possible as a form)
Customer Name = George (Chosen from a drop down list)
% of allocations = 25
Customer Code = 123 (Populated automatically based on the Customer Name)
Customer Name = Adam
% of allocation = 75
Customer Code = 345
The popup would go away once the total of the % allocation column = 100%
The values are then returned onto a adjacent spreadsheet
Customer Name - Amount - Code - Type
George - 19.28 - 123 - Meals
Adam - 57.84 - 123 - Meals
Please help!
Thanks
Dianna
Hope you can help me....I would like to have a cell be broken down into
multiple layers...
The spreadsheet is as follows...
A9=date
B9=comments
C9=Expense Type (Meals, Cell, or Travel)
D9=total expense
E9=Tax
F9=Total for GL entry
Once C9, D9 and E9 are entered; F9 calculates based on macros and formulas.
Now what I would like to do, is...once F9 calculates, the user to be
prompted to enter the following additional information from drop down
lists...Customer Name, % allocated and Customer Code. The results then
displayed on a adjacent worksheet
Example:
A9 - 3/18/08
B9 - none
C9 - Meals
D9 - 79.00
E9 - 3.76
F9 = 77.12
Popup box asks for additional information (possible as a form)
Customer Name = George (Chosen from a drop down list)
% of allocations = 25
Customer Code = 123 (Populated automatically based on the Customer Name)
Customer Name = Adam
% of allocation = 75
Customer Code = 345
The popup would go away once the total of the % allocation column = 100%
The values are then returned onto a adjacent spreadsheet
Customer Name - Amount - Code - Type
George - 19.28 - 123 - Meals
Adam - 57.84 - 123 - Meals
Please help!
Thanks
Dianna