Sedang Disiapkan

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

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.

Kemahiran: Excel, Visual Basic untuk Aplikasi

Lihat lebih lanjut: matching logic, month spreadsheet, print vba, in vba, end vba, a b, vba e, validate excel, row spreadsheet, row b, hh, excel visual basic, excel vba, printer program, create report, create excel, vba excel copy, spreadsheet vba code, excel row column, excel vba report, sheet excel visual basic, excel column row, excel vba print, excel format cell, excel cell format

Tentang Majikan:
( 24 ulasan ) OLV-Waver, Belgium

ID Projek: #4044590

Dianugerahkan kepada:

deepbluetech

I can take on the job. Let me know.

€30 EUR dalam sehari
(84 Ulasan)
5.2

17 pekerja bebas membida secara purata €30 untuk pekerjaan ini

dominique1

No problem, I can write a macro/procedure for this.

€30 EUR dalam sehari
(86 Ulasan)
5.2
pkcyber

see your pMB

€30 EUR dalam sehari
(17 Ulasan)
5.1
diegogarcia0531

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
(10 Ulasan)
4.3
samitXI

Please check your inbox. Thanks

€30 EUR dalam sehari
(15 Ulasan)
4.2
naveenvarthaan

Hi ExpertProjectMgr, I am delivering the code in one hour Best Regards, Naveen

€30 EUR dalam sehari
(11 Ulasan)
4.1
expertatwork

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
(16 Ulasan)
3.6
manishadk

This is Very Easy Task For Me. Please Check PMB For Details.

€30 EUR dalam sehari
(9 Ulasan)
3.6
dobreiiita

ready to start the work.... confident in completing the project in one day

€30 EUR dalam sehari
(5 Ulasan)
2.6
salih0vicx

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
(3 Ulasan)
2.6
AnnRay

Sir, I am interested to apply for this project.

€30 EUR dalam 2 hari
(3 Ulasan)
2.2
glddgunawardana

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 sehari
(1 Ulasan)
1.8
spiritofhimalya

Really easy, i can help. thanks

€30 EUR dalam 0 hari
(1 Ulasan)
1.0
whayes

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 sehari
(0 Ulasan)
0.0
ansonjonel

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 Ulasan)
0.0
WorkingSmart115

I can handle this project without a problem. I work full-time as an engineer and have a lot of experience with Excel & VBA.

€30 EUR dalam sehari
(0 Ulasan)
1.0
JasonWittenauer

Hi. This should be a quick project.

€30 EUR dalam sehari
(0 Ulasan)
0.0