Data Processing With VBA

Hi everyone, this is my first post here so i apologize in advance for any mistakes.

Currently i am working with Dynamo and Revit to Extract model data to Excel, and further process these Data .
In the following picture, as you can see, the top row are the parameters and the cells below are their corresponding values. Some parameters does not any value therefore the cell below the name is empty, But if there's any value, the cell below will be stored with the value ( e.g. Column AED ). At the same time some parameter's names will be the same, but only one parameter of that name type will be stored with a value ( for example, There are multiple "DESCRIPTION"s but only the one on Column AED is stored with the value "CW2 Secondary Truss"
Capture.JPG

The action i wish to complete with these data is to remove the duplicates that have no value stored, but keep those which a value has been stored
For example : to remove the "DESCRIPTION" duplicates on column ADX,ADY and AEB and make them blank but keep column AED

However, i hope that the VBA macro will automatically look for duplicates without me enter what duplicates should it search for. I was thinking of using an array and store new names into the list, and compare the current cell with the name list to see if the cell is a duplicate.

Is there any way i can do that? if so , how should i do it?

Hello ZacharyTso,

See if the following VBA code works for you:-

Please Login or Register  to view this content.

The code assumes that there are headings in Row1.

The code also assumes that an array of criteria are in a second sheet("TestArray") starting in Row 2, Column A.

I've attached a little sample workbook for you to show how the code works. Click on the "RUN" button to see it work.

I hope that this helps.

Cheerio,
vcoolio.