I gang

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.

Færdigheder: Excel, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 24 bedømmelser ) OLV-Waver, Belgium

Projekt-ID: #4044590

Tildelt til:

deepbluetech

I can take on the job. Let me know.

€30 EUR på 1 dag
(84 bedømmelser)
5.2

17 freelancere byder i gennemsnit €30 for dette job

dominique1

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

€30 EUR på 1 dag
(86 bedømmelser)
5.2
pkcyber

see your pMB

€30 EUR på 1 dag
(17 bedømmelser)
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 in 0 dage
(10 bedømmelser)
4.3
samitXI

Please check your inbox. Thanks

€30 EUR på 1 dag
(15 bedømmelser)
4.2
naveenvarthaan

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

€30 EUR på 1 dag
(11 bedømmelser)
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 in 0 dage
(16 bedømmelser)
3.6
manishadk

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

€30 EUR på 1 dag
(9 bedømmelser)
3.6
dobreiiita

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

€30 EUR på 1 dag
(5 bedømmelser)
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 in 0 dage
(3 bedømmelser)
2.6
AnnRay

Sir, I am interested to apply for this project.

€30 EUR in 2 dage
(3 bedømmelser)
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 på 1 dag
(1 bedømmelse)
1.8
spiritofhimalya

Really easy, i can help. thanks

€30 EUR in 0 dage
(1 bedømmelse)
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 på 1 dag
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
1.0
JasonWittenauer

Hi. This should be a quick project.

€30 EUR på 1 dag
(0 bedømmelser)
0.0