Macro to copy range cells from a worksheet to another and color the rows in the new worksheet based on conditions.

Befejezett Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

need script to copy cells and process them.

Instructions:

[url removed, login to view] buton to start process (c3) in MVP GIS DATA QC

[url removed, login to view] D1 to END to a new spreadsheet(MVP DATA CHECKER)

[url removed, login to view] on below CASES color rows red or green

CASES

--1

IF Pending Replacement= yes and Validation Complete yes

then color entire row in GREEN

--2

IF Pending Replacement= yes and Validation Complete No

then color entire row in RED

--3

IF Pending Replacement= NO then

(

IF Mapping Verification Reqd = NO and

if ANY --> (UnmappedPipe/Fitting,Fitting Errors,Location Errors,Length Errors (>20'),Diameter Errors,Material Errors,Insert Sleeving Errors,Landbase Errors) = YES

then make ROW RED

ELSE

------------

IF Mapping Verification Reqd =Yes and Validation Complete = NO

then

(

IF Discrepancy Severity = major and asbuiltfound = Yes

then

IF any (UnmappedPipe/Fitting,Fitting Errors,Location Errors,Material Errors,Insert Sleeving ) are yes

)

then Make ROW Green

---------------

ELSE IF Mapping Verification Reqd =Yes and Validation Complete = YES

THEN make ROW RED

)

--4

IF Pending Replacement= NO

(

IF Mapping Verification Reqd = NO and

if ANY --> (UnmappedPipe/Fitting,Fitting Errors,Location Errors,Length Errors (>20'),Diameter Errors,Material Errors

,Insert Sleeving Errors,Landbase Errors) = YES

then RED ROW

ELSE

-------

IF Mapping Verification Reqd =Yes and Validation Complete = no

then

(

IF Discrepancy Severity = minor

and check asbuiltfound, if Yes then

IF any (Length Errors (>20'),Diameter Errors,Landbase Errors)

are yes

)

then Green Row

-------------

ELSE IF Mapping Verification Reqd =Yes and Validation Complete = YES

THEN RED ROW

)

Excel Macros VBScript

Projektazonosító: #16074654

A projektről

2 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

Odaítélve:

$25 USD 1 napon belül
(3 értékelés)
1.0

2 szabadúszó tett átlagosan 25$ összegű árajánlatot erre a munkára

ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) Relevant Skills and Experience I guarantee you an accurate job, full functionality and Továbbiak

$25 USD 1 napon belül
(1 Visszajelzés)
0.4