It's less of a question, more of a cry for help! I have set up a datasheet with information to be used in generating several
Column A - Our Invoice Number
Comunn B - Vendor's Invoice Date
Column C - Type of Vendor (Labor, PM, Subcontractor, Material, or Equipment)
Column D - Vendor Name
Column E - Vendor Invoice Number/Time Classification (Column C is Labor, PM, this is either Regular Time or Overtime. If
Column C is Subcontractor, Material, or Equipment, the Vendor's Invoice Number is enetered.)
Column F - Labor Hours Worked (Column C is Labor or PM, a value is entered, if not, formula enters "N/A")
Column G - Labor Rate ((Column C is Labor or PM, vlookup value is entered, if not, formula enters "N/A")
Column H - Amount Billed ((Column C is Labor or PM, formula multiplies rate by hours, if not, enter the amount of the
Column I - Mark Up Percentage
Column J - Mark Up Amount
Column K - Total Amount Billed (Column H + Column J)
I need to set up a daily job sheet (like and invoice) for
each date listed under Column B. For each day, I need to generate a daily job sheet showing all of that day's information.
The location of the information is based on the value in Column C - Subcontractors's data go in one spot on the sheet and
Labor costs go in another place.
Is this possible in Excel through formulas?
I am woefully inept at
Any help would be greatly appreciated!