Excel Fx for Generating an invoice

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Before you apply-

You must have a way to communicate via talking… (Not only through chat)

You must have a reliable internet connection

Be able to speak fluent English….

NEED THIS COMPLETED EITHER TONIGHT SO I CAN USE TO PRODUCE INVOICE...Thanks: 

I have an excel sheet with over 400 entries.

I am adding entries here and there, but the majority of entries are in the sheet.

Each entry is for the job that needs to be invoiced.

An entry in short, details the days Items worked on by a tech, or multiple techs, or multiple companies on the job.

This job got out of hand with change orders.

So we have an AddOn/change order sheet which allows us to add and track the Add/change orders given. I am adding entries here and there, but the majority of entries are in the sheet as well.

this sheet has about 200 entries on it.

Have a drop down sheet

Data from drop down menus is used to populate the sheets

On a job- Each day a time sheet is filled out. Entries we enter into the workbook, come from these time sheets….

The time sheet has the following data that is entered into the work book….

Sheet DATE

Sheet # NAME

# Of Techs for the entry

Start Date/time

End Date/Time

Hours total before breaks

Breaks taken

Total hours for the line (row)

Part # (part of the job- we have bid parts, Time and material parts and so on, each part is given a Letter EX: 4881.B WL Tile- is part B – we are installing Tile Wainscoting

Item # (each detail of a part would have an Item #. these item numbers are mainly used to track details of each part of the job.)

Room Code (each room on the job has a room code)

Notes

# of Tech/crew on the job (for the company on the line item

Trucks on the job

Lodging Type

Lodging Number

Completed

Notes for Sheet

This job got out of hand with change orders.

So we have an AddOn/change order sheet which allows us to add and track the Add/change orders given. I am adding entries here and there, but the majority of entries are in the sheet as well.

Data from drop down menus is used to populate the sheets

NEED to be able to enter a query for the following to generate invoices and paying subcontractors.

I would like to pull the different queries for my ranges on the drop down sheet I made.

Would like to get results and multiple both results in column lists and Concatenating comma separated.

Need to be able to query and group by all…

date range

Job Parts

Item #s

Rooms

Crews

Hours

Techs onsite

Lodging info

Trucks onsite

etc...

(in word doc)

Timesheet entry sheet

Add-ons sheet

Dropdown sheet (named ranges)

I can give you a backup of the sheet I'm using but once the formula is written need to insure it works on the sheet I'm using…

Before you apply- you must have a way to communicate via talking… and you must have a reliable internet connection and be able to speak and under English….

Thanks

Excel Excel Macros Excel VBA VBScript Visual Basic

Project ID: #18526472

About the project

6 proposals Remote project Active 5 years ago

Awarded to:

urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam More

$50 USD in 10 days
(45 Reviews)
5.7

6 freelancers are bidding on average $56 for this job

lightingdavid

Hello? How are you? I have good experiences in "Excel Fx for Generating an invoice" as you can see my profile for these (Excel, Excel Macros, Excel VBA, VBScript, Visual Basic). I have been working for 7 yrs in this More

$55 USD in 3 days
(105 Reviews)
6.0
lorezoshierlymay

If you want it to be done in a day or two. Hire me.

$66 USD in 1 day
(0 Reviews)
0.0
akshaypunjabi

I have been working extensively on Excel as well as VBA over the last 4 + years and have created multiple automated Dashboards, reports, templates, Scrapers etc. for clients across different verticals. I am known f More

$45 USD in 1 day
(0 Reviews)
0.0