Excel Macro Basic For Demo. If pass then can hire for remote support on contract basis.

Check this very easy basic microsoft Excel macro Preparation

1 File 1 : 192_168_0_0_23_Part1_2  Input File

2. File 2 : Vulnerability  Output File

This is simple Macro , we have to present it as a Demo .

Then after check & confirm we can discuss about remote support contract.

It is paid service after this demo we present.

• Input : There are 2 Files  [ File 1 and File 2 ].

• Output : We have to create a MACRO to take input from File 1 and put in file2

o Create a New Fancy Button in SHEET-1 in NEW FILE (when click -> ask to Import File 1 and display result in File 2 ), maintaining the previous data in file 2.

• Activity

1. In, File 1 (Column D / RISK)  Filter out LOW and NONE ( no need to copy that)

2. Column Mapping File 1 < -> File 2

File 1 – Column B File2 – Column K

File 1 – Column C File 2 – Column L

File 1 – Column D File 2 – Column J

File 1 – Column E File 2- Column F

File 1 – Column J File 2 – Column C

File 1 – Column K File 2 – Column D

3. In File 1 -If you find any word called NESSUS make it blank.

4. Rest other column in File 2 will remain blanks

.NET Procesamiento de datos Excel Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #18364878

Sobre el proyecto