J
jcliquidtension
Hi,
I have a spreadsheet that will compile billing information based on an input
sheet with check boxes. On the input sheet, the user inputs name, employee
ID, and then clicks check boxes under each category of service performed.
The check boxes are in each cell, and linked to the cell in which they're
contained.
INPUT EXAMPLE:
Name ID U.S. return State return etc.
John D. 556556 true true
Jane D. 445445 true false
etc.
Anyway, my goal is to create a report that lists out by row by row:
REPORT EXAMPLE
Name ID Service Amount
John Doe 556556 U.S. Tax Return $600
John Doe 556556 AZ Tax Return $150
Jane Doe 445445 U.S. Tax Return $600
etc.
(The amount pulls from a table that the user will not see. It populates
based on country chosen from a drop-down box, and for each country, the user
must enter a password for the amounts to populate. This is so China doesn't
know what Taiwan is being paid for a U.S. return, etc.)
Thanks in advance!
Jason
I have a spreadsheet that will compile billing information based on an input
sheet with check boxes. On the input sheet, the user inputs name, employee
ID, and then clicks check boxes under each category of service performed.
The check boxes are in each cell, and linked to the cell in which they're
contained.
INPUT EXAMPLE:
Name ID U.S. return State return etc.
John D. 556556 true true
Jane D. 445445 true false
etc.
Anyway, my goal is to create a report that lists out by row by row:
REPORT EXAMPLE
Name ID Service Amount
John Doe 556556 U.S. Tax Return $600
John Doe 556556 AZ Tax Return $150
Jane Doe 445445 U.S. Tax Return $600
etc.
(The amount pulls from a table that the user will not see. It populates
based on country chosen from a drop-down box, and for each country, the user
must enter a password for the amounts to populate. This is so China doesn't
know what Taiwan is being paid for a U.S. return, etc.)
Thanks in advance!
Jason