Suoritettu

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

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

)

Taidot: Excel Macros, VBScript

Näytä lisää: macro to copy data from one workbook to another based on criteria, excel move row to another sheet based on cell value, excel vba copy rows from one sheet to another based on criteria, excel copy row to another sheet if, excel vba copy cells based on criteria, excel copy rows from one sheet to another based on criteria, if column contains value then copy row to new sheet, excel vba copy row to another worksheet based on cell value, i want to manufacture new products what do i need to know, macro copy text word based heading, excel macro copy paste empty cells, excel copy format cells macro, macro copy rows excel based cell content, excel macro copy paste cells automatically, macro copy selected cells data

Tietoa työnantajasta:
( 1 arvostelu ) Phoenix, United States

Projektin tunnus: #16074654

Myönnetty käyttäjälle:

$25 USD 1 päivässä
(3 Arvostelua)
1.0

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$25 USD 1 päivässä
(1 arvostelu)
0.4