Find Jobs
Hire Freelancers

Create a report from a row in excel and print it.

€30-40 EUR

Selesai
Dibuat lebih dari 11 tahun yang lalu

€30-40 EUR

Dibayar ketika dikirim
Everyday, a row is added to the 'DATA' sheet in the spreadsheet in attachment. Following values are written to a new row: - the date is put to three cells in A, B and C: year (format=yyyy), month (numeric), day - time is put to three cells in D, E and F: hh (hours), mm (minutes) and ss (seconds) - numeric values (floating numbers) are written to columns G upto P (see 'Field 1' up to 'Field 10') When a new date is entered in cell S1, following logic is executed: 1. Validate if the entry in S1 is a valid date. If not, end the program 2. Verify if the date corresponds to a row in the sheet. It should match a date in columns A, B and C. If no match is found, end the program. If more than one match is found, select the last matching row (the one with the highest row number) 3. For the row that was found in the previous step, 3a. copy the values in the cells on column G, H.. to P to the corresponding cells in the 'PRINTREPORT' Sheet. 3b. copy the date and time found on the row found in step 2 to cells C8 and E8 respectively. 3c. print the 'PRINTREPORT' sheet to a specific printer specified in cell B1 on the sheet 'PARAMETERS'.The report will be printed to this printer, in case the cell B1 is blank, print to the default printer. NOTES - the code should be added as modules in the sheet in attachment in VBA. - the version of excel is 2010.
ID Proyek: 4044590

Tentang proyek

16 proposal
Proyek remot
Aktif 11 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
I can take on the job. Let me know.
€30 EUR dalam 1 hari
5,0 (205 ulasan)
7,4
7,4
16 freelancer menawar dengan rata-rata €30 EUR untuk pekerjaan ini
Avatar Pengguna
Hi ExpertProjectMgr, We are a very confident team and we can deliver you the product with awesome quality. Please reply if you have any questions. Looking forward to work with you. thanks !
€30 EUR dalam 0 hari
4,8 (150 ulasan)
5,8
5,8
Avatar Pengguna
see your pMB
€30 EUR dalam 1 hari
4,9 (31 ulasan)
5,6
5,6
Avatar Pengguna
No problem, I can write a macro/procedure for this.
€30 EUR dalam 1 hari
5,0 (66 ulasan)
5,1
5,1
Avatar Pengguna
Hi, I can do the job, Excel expert, VBA developer Please check PMB I am looking forward to work with you regards Diego
€30 EUR dalam 0 hari
5,0 (19 ulasan)
4,9
4,9
Avatar Pengguna
Please check your inbox. Thanks
€30 EUR dalam 1 hari
5,0 (25 ulasan)
5,0
5,0
Avatar Pengguna
Hello Belgium :-) I am dedicated professional with over 16 years of experience in programming; certified by Microsoft back in 2000; visited Brussels 1999 :-).... Cheers from cold Bosnia -
€30 EUR dalam 0 hari
5,0 (11 ulasan)
4,5
4,5
Avatar Pengguna
Hi ExpertProjectMgr, I am delivering the code in one hour Best Regards, Naveen
€30 EUR dalam 1 hari
4,8 (23 ulasan)
4,6
4,6
Avatar Pengguna
ready to start the work.... confident in completing the project in one day
€30 EUR dalam 1 hari
4,9 (17 ulasan)
4,0
4,0
Avatar Pengguna
This is Very Easy Task For Me. Please Check PMB For Details.
€30 EUR dalam 1 hari
4,8 (16 ulasan)
4,1
4,1
Avatar Pengguna
Sir, I am interested to apply for this project.
€30 EUR dalam 2 hari
5,0 (3 ulasan)
2,4
2,4
Avatar Pengguna
Dear Hiring Manager, I'd like to do this project for you, I'm very detail-oriented and accurate which it's exactly what this kind of project needs. I hope to be considered for the project. Thanks!
€30 EUR dalam 1 hari
5,0 (2 ulasan)
1,8
1,8
Avatar Pengguna
Really easy, i can help. thanks
€30 EUR dalam 0 hari
5,0 (1 ulasan)
1,0
1,0
Avatar Pengguna
I am new to freelancer so I would like to do this to gain some credibility. I can have this done for you in less than a day.
€30 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi. I have many years of experience in excel and macros. I did the download of the file and i know how to do the macro for your requirement. Regards.
€35 EUR dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi. This should be a quick project.
€30 EUR dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera BELGIUM
OLV-Waver, Belgium
5,0
24
Memverifikasi Metode pembayaran
Anggota sejak Mei 28, 2007

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.