Delmaine insert column

Hi Rashed,

I have a new project for you. This should be somewhat simpler than the previous.

I would like a macro that can run on the attached sheet (data source) and add a column with the value based on rules.

Hi Rashed,

I have a new project for you. This should be somewhat simpler than the previous.

I would like a macro that can run on the attached sheet (data source) and add a column with the value based on rules.

The data source layout will always be the same. That is it will have the same number of columns and start on row 10.

I would like the macro to add column AC. The title for AC on row 9 will be “Status”.

For each of the rows of data (starting on row 10), AC is to be set as follows based on the values in T, W, X, Z and AB.

- If T, W, X, Z and AB are all populated. AC = Delivered
- If only T, W, X and Z are populated (AB not populated AC = Arrived
- If T, W & X are populated (Z & AB not populated) AC = Shipped
- If T and W are populated (X, Z & AB not populated) AC = Booked
- If only T is populated (W, X, Z & AB not populated) AC = Placed

The user should be able to specify where the new output is to be saved. I expect the interface will also ask for the source file ?

Please advise what the cost of this project will be.

Happy to answer further questions.