how to make an spread sheet to calculate piece work codes from wor

J

Jay

Hey all I'm extremely new to exel and I'm looking to get a spread sheet that
I would be able to enter about 50 codes that I have a list for. I'm an sub
contractor and get paid by piece work. The codes we use have a number like
045 which is worth $30 say. Im looking for a template that I could enter all
work codes with values in the address that I did the work at. And then a
total dollar amount be calculated. That pretty much the hard part. Mainly I
need to have the date, place, codes calculated into dollars after I have
inputed the work codes done. And a place for any equipment I have installed
or taken. Then finally keep a total for a month at a time. Any help would be
great. Thanx alot


Veg420
 
M

Mary

Hey Jay

You need a spread sheet with drop down boxes. I have gone ahead and did a
sample for you. I could be writing all night trying to tell you how to set
it up.
e-mail me if you want my help.
(e-mail address removed)

Have a good day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Calculate selected worksheets 5
Make VBA ComboBox_Change work in 3 sheets 1
Calculations with possible null value fields 1
How do I set up a spread sheet in excel 1
how to compare data and see variances by year 1
Access 2003 --> Access 2007 code no longer working 6
Create a document from a spread sheet using data from another spre 1
Lookup whole sheet and add datas from specified date to end date 0

Top