Lengkap

Excel: VB Form Development -- 2

Attached is my Job Register and Job Costing / Labour Allocation Spreadsheet.

Currently it operates as follows:

• The “admin reg” sheets is updated every time a new job/project comes in and is then updated periodically to show progress etc. The column “spent hours” pulls in the sum of hours matching the job no from the “all data” tab.

• The “weekly labour allocation” tab is then filled out weekly assigns hours per man to a specific job number. I then copy and paste this data at the end of the week into the “all data” sheet so that the “admin reg” can pull the hours off for the whole year.

• Most of the other sheets/tabs are just pivot tables etc

So what I want to achieve is as follows:

• A separate form to input data into the “admin reg” i.e. new job details as they arise. As you can see from the spreadsheet, some of the fields require data input and some are then calculated as you can see in the formulas so the form would have to allow for this. i.e. the VB script would have to allow for this. When the data is inputted via the form it would update the database which would be on a separate tab/sheet to the form. The form should be permanently embedded a new sheet/tab called data input or something similar.

• The other form would then be to input daily labour allocation which would immediately update the “all data” sheet. It would need to have a drop down menu of the staff names whereby you select the staff name, input the job number, and the number of hours at NT, OT and DT. There would also be a facility to enter a comment since I like to be able to filter by comments aswell. You can see this in the spreadsheet as it is at the moment. The vast majority of the columns in the all data sheet is information pulled from the admin register once the job number has been entered. So again the form would need to allow for this.

Kemahiran: Excel, Visual Basic

Lihat lagi: nt job, job nt, job in nt, excel, excel form to enter data, input form updates excel database, import excel window application form vb net, hoe data form excel sheet write database perl, excel form vb editor, enter data database data entry form vb, data entry form front end vb excel backend, code store text form vb project ms access database, submit form data excel database asp, excel front end database, excel data access database

Tentang Majikan:
( 1 ulasan ) Midleton, Ireland

ID Projek: #8203812

Dianugerahkan kepada:

barkatmulani

Although new to this freelance website, I have a well reputed freelancer profile on ELance ([login to view URL]). I started working in Excel since the start of my career in 1998. MS Office used to Lagi

€40 EUR dalam 3 hari
(6 Ulasan)
2.9

20 pekerja bebas membida secara purata €115 untuk pekerjaan ini

zExcel

A proposal has not yet been provided

€175 EUR dalam 2 hari
(254 Ulasan)
7.6
lukaszoz

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Lagi

€39 EUR dalam 3 hari
(30 Ulasan)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regard Lagi

€155 EUR dalam 3 hari
(206 Ulasan)
6.8
DanielVizcaya91

Hello there, I will like to help you out with this project. I am a freelancer with a lot of experience using excel. I have developed similar programs in Excel so I am sure I can handle this task and deliver it exactly Lagi

€98 EUR dalam 3 hari
(86 Ulasan)
6.7
expertatwork

we can do this VBA user forms... please reply... thank you...

€57 EUR dalam 2 hari
(190 Ulasan)
6.0
kannasanthosh

Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics pro Lagi

€133 EUR dalam 4 hari
(36 Ulasan)
5.6
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features li Lagi

€150 EUR dalam 3 hari
(66 Ulasan)
5.5
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in Exchange data between sheets, Critical Programming, Developing System for Management and Creating Reports. Read and understood your project descrip Lagi

€100 EUR dalam 5 hari
(61 Ulasan)
5.2
surekash7096

I have the expertise in excel and VB forms and implement the forms as per your specifications with accuracy. Ready to start work immediately

€111 EUR dalam 2 hari
(67 Ulasan)
5.2
slenders13

Hey, I have a lot of experience with VB and Excel. Send me a message for more Information. I work hard and deliver a complete project. Kind Regards, Rens Slenders SlenDATA

€50 EUR dalam 4 hari
(20 Ulasan)
4.7
vivirain

A proposal has not yet been provided

€90 EUR dalam 4 hari
(10 Ulasan)
3.7
smtpccnt

A proposal has not yet been provided

€72 EUR dalam 2 hari
(5 Ulasan)
3.1
SWAPANCHOWHAN

Dear Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have already worked in projects similar related to VBA macros for excel and vb.net. This w Lagi

€44 EUR dalam 3 hari
(5 Ulasan)
2.3
mjreddy03

Hello, I am good at excel & VD scripting.I am interested and can done it for you for €60. Regards Jagadeesh

€66 EUR dalam 3 hari
(0 Ulasan)
0.0
rrichie

The following are my skills; Languages: VB 6.0, ASP.Net, C#.Net, VB.Net, ASP.Net MVC Web Technologies: HTML5, XHTML, XML, JavaScript, AngulerJS Databases: MS SQL Server 2005, 2008 and 2012, Oracle 10g, MySQL Techno Lagi

€155 EUR dalam 3 hari
(0 Ulasan)
0.0
Joe7719

I have a lot of experience developing forms and macros in excel VBA. The job looks interesting and I think I can do it in three days.

€144 EUR dalam 3 hari
(0 Ulasan)
0.0
harishsaidu4u

!!!!SAMPLE WORKING MODEL CREATED AND SHARED VIA MESSAGE!!!! I am an IT professional with 10 years of experience with in depth experience in usage of excel for creating various charts, reports and macros which is an Lagi

€155 EUR dalam 2 hari
(0 Ulasan)
0.0
sudhnashu2011

We the team of 3cm have skilled employee to perform the work. We also have training in the same field. We also have long experience in this type of job.

€238 EUR dalam 3 hari
(0 Ulasan)
0.0
amitsharma50401

A proposal has not yet been provided

€222 EUR dalam 6 hari
(0 Ulasan)
0.0