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

已完成 已发布的 6 年前 货到付款
已完成 货到付款

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

项目ID: #16074654

关于项目

2个方案 远程项目 活跃的6 年前

授予:

$25 USD 在1天内
(3条评论)
1.0

有2名威客正在参与此工作的竞标,均价$25/小时

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 更多

$25USD 在1天里
(1条评论)
0.4